Forum Discussion

Ashish_kumar12's avatar
Ashish_kumar12
Helper I
5 years ago
Solved

Year over Year Data Comparison

Hi There , Hope you doing well, I want to create an measure showing Year to Year Total sales in column chart however i want that calculation to pick automatically upcoming year data also e.g 2017,2...
Help
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Ashish_kumar12 ,

     

    First I created a calendar table.

    Table = 
CALENDAR(
    MIN(Sheet2[date]),
    MAX(Sheet2[date])
)

    Then I created table relationship.

    Then I used your measure formula.

    Sales LY = 
CALCULATE(
    SUM(Sheet2[Value]),
    DATEADD( 'Table'[Date], -1, YEAR )
)

     

    Best regards,
    Lionel Chen

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

lbendlin's avatar
lbendlin
Super User
5 years ago

Look at the "Quick Measures" option in Power BI, it has templates for such a scenario.

 

Make sure that you have a proper calendar table, too.