Forum Discussion

raicardi's avatar
raicardi
Frequent Visitor
4 years ago
Solved

Year over Year Data table and cluster chart

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

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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