Forum Discussion
nsadams87xx
6 years agoHelper III
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 ye...
amitchandak
6 years agoSuper User
You can also use year behind measure with Date dimesnion
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))