Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to count all contracts from a table and show it in a bar chart. As a dimensions I want to set all months of a CURRENT year, but I don't know why. Simple condition =MONTH([ISSUANCE DATE]) is not enough, I need to declare also a year: 2024, or YEAR(DATE(TODAY())). I tried with limitation, but without success.
Currently it counts contracts of all months from all possible years.
For Dimension, you can use the expression below and untick 'Include null values':
IF(Year([ISSUANCE DATE]) = Year(Today()), MONTH([ISSUANCE DATE)])
or by using set analysis in your measure expression, for example, if your measure is sum of field, use expression as below and just set the dimension as Month([ISSUANCE DATE]):
SUM({$<[ISSUANCE DATE] = {">=$(=YearStart(Today()))<=$(=Today())"}>} field)