Work Anniversary

[AlanP514]

Hai All I am new to Dax Need your help,

I want to visualize Month V/S Count people who are celebrating work anniversaries
I Want to show like Dec 2021 = 2(Count Of people celebrating anniversaries)
Jan 2022 = 3
Feb 2022 = 5
March 2022 =6

 

[v-yalanwu-msft]

Hi, @AlanP514 ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions or share it? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi AlanP,

Let's presume your data looks something like this:

Then in the report use measure:

Number of Birthdays = COUNTROWS('Employee Birthday')
Then play around with the visuals a bit 😉

Kind Regards,

Koen