Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi,
I am trying to create an YTD for an count of categorical variable for each event type. The data is similar to this. Now I have to create a count of rating difference from 2021-2022. How do I proceed with that ?
I used this
Solved! Go to Solution.
Hi @Anonymous,
You may try this solution.
1 Make some changes to your Measure
RATING_YTD = TOTALYTD(Count(Sheet0[rating]),Sheet0[response date].[Date])
2 Create a visual like this
Also, attached the sample pbix file.
For more details about TotalYTD, you may take a look at Year to Date; TotalYTD part of this blog: Basics of Time Intelligence in DAX for Power BI; Year to Date, Quarter to Date, Month to Date - RADACAD
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
Best Regards,
Community Support Team _ Caiyun
Hi @Anonymous,
You may try this solution.
1 Make some changes to your Measure
RATING_YTD = TOTALYTD(Count(Sheet0[rating]),Sheet0[response date].[Date])
2 Create a visual like this
Also, attached the sample pbix file.
For more details about TotalYTD, you may take a look at Year to Date; TotalYTD part of this blog: Basics of Time Intelligence in DAX for Power BI; Year to Date, Quarter to Date, Month to Date - RADACAD
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
Best Regards,
Community Support Team _ Caiyun
Hi,
Try something like this:
Data:
Model:
DAX:
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/
Proud to be a Super User!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.