Forum Discussion

nsadams87xx's avatar
nsadams87xx
Helper III
6 years ago

Calculate percent difference between two Matrix Columns

Hey everyone,

 

I have a dataset that has previous year's data and this year's data in one column:

 

 

Is there a way I can calculate the sum percentage delta between the previous year and the current year as it sits or do I need to modify the data model?

 

General Comment
Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    You can also use year behind measure with Date dimesnion

    Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))