Forum Discussion
Period over Period comparison
Hi, I need to display just 9 months of data for each year for 2018, 2019 and 2020 to compare frequencey for top 5 causes. .i.e., i need to display data in a chart for date starting from 01/01/201...
Hi Anonymous,
I'd like to suggest you create a calculated table with the date value you required and use it on the legend field, then you can write measure expressions to extract the current category and redirect to particular calculate formulas that filter by the current legend:
If the above does not help, can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hello Anonymous ,
Can i have some update?
To breif you more about it. I need to compare Top 5 causes of Loss Range for the year 2021 with Same top 5 causes of 2021 but the loss range year would be 2020.