Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Year-over-Year Change Calculated Column

Hello,   I am trying to create a matrix that shows the monthly data for the current year and prior year, along with an additional column that shows the % change. I currently have the following matr...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , Try new measures and use switch values on rows. Show values on rows (in Matrix Visual)

 

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))

 

diff = [MTD Sales]-[last MTD Sales]
diff % = divide([MTD Sales]-[last MTD Sales],[last MTD Sales])

 

Or use calculation group

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0