Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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...
Need Help
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

Adjust your formula to something like this...

Months =
CALCULATE (
    DISTINCTCOUNT ( 'Calendar Table'[Year-Month] ),
    'Calendar Table'[Date] <= TODAY ()
)

Hope this helps! :smileyhappy:

wzkoral's avatar
wzkoral
Icon for Advocate II rankAdvocate II
6 years ago

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 .