Year over Year AND Month over Month with two categories

[ahhollan]

I need a line or bar chart to show year over year comparison for two categories but also show month at same time. Is that possible? My data shows the columns 'Reported Date' and Category with values of Covid or Non-Covid. I need to show Year over year comparision by month. I'm new to Power BI and using quick measures and DAX. Any help would be appreciated.

[v-xulin-mstf · Accepted solution]

Hi @ahhollan,

You can try this:

Here is the demo, please try it: Year over Year AND Month over Month with two categories

Best Regards,

Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[nandic]

Hi @ahhollan ,
You could check accepted solution on this link, it is pretty the same topic: https://community.powerbi.com/t5/Desktop/Year-over-Year-calculation/td-p/75403 
In other words, there are several ways to combine current and previous year (DateAdd function, SamePeriodLastYear, PreviousYear) - you might check more about these functions for easier use.

Regards,
Nemanja Andic