Forum Discussion
Count months with non-blank data
Hello friends, I have created a dynamic "Headcount" measure, that shows the number of men-Months/Quaters/Years dynamically depending on what the user chooses. For example if an employee works full-t...
Adjust your formula to something like this...
Months =
CALCULATE (
DISTINCTCOUNT ( 'Calendar Table'[Year-Month] ),
'Calendar Table'[Date] <= TODAY ()
)Hope this helps! :smileyhappy:
What kind of relation do Yuo have beetwen date_table and facts . I am asking beacause have some isue with this formula. Looks tha same but in every period (Year, quater mounth ) i have total result .