Forum Discussion
Power BI DAX for sub category
I am having a dataset at the below Month Week Number Userid Ratings Dec-21 W52 94 Disagree Dec-21 W53 95 Strongly Agree Dec-21 W54 96 Neutra...
ValtteriN
Community Champion
Community ChampionHi,
For MTD do this:
1. create a calendar table and relationship to you fact table:
2. create MTD measure like this:
Rating_MTD = CALCULATE([Measure 43],DATESMTD('Calendar'[Date]))
(The measure 43 is just COUNT of the UserID table)
3. End result:
(The measure 43 is just COUNT of the UserID table)
3. End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/