Forum Discussion

AlanP514's avatar
AlanP514
Icon for Post Patron rankPost Patron
4 years ago

Work Anniversary

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

 

Need Help
Show and Tell

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.