Year over Year Data table and cluster chart

[raicardi]

I am trying to create a YoY table and chart based on the below data. When I follow other suggestions, i am not getting the results I need, no matter what date in the fields I am choosing. 

Sample data below. I am trying to show incidents YoY, and eventually compared vs previous years months, quarters, etc.

https://docs.google.com/spreadsheets/d/182ShbgQ7-og_tigZF5T_ewvbuSYFfbzOfwVSx8NvQEU/edit?usp=sharing

[Anonymous · Accepted solution]

Hi @raicardi , 

You can do that with the DATEADD function

Step 1: Clean your excel Data >> On the date column Find and replace 0:00 with blank
Step 2: Load your excel to Power Bi
Step 3: Create a new measure

Count of Index LY = 

CALCULATE(
    COUNT(Sheet1[Count of INCIDENT]),
    DATEADD(Sheet1[DATE],-1,YEAR)
)

Step 4 : Visualize

If that helps, please mark this as a solution

BR