Forum Discussion
Display Measures on Each Row in Matrix
Hello, I have a request regarding the calculation of Month to Month sales growth for company and the whole market for a certain product in different cities, Here is an example. The final repo...
amitchandak
Super User
Super UserPBI3000 , Create a date tanle join with you table and then have measure like
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
diff = [MTD Sales]-[last MTD Sales]
diff % = divide([MTD Sales]-[last MTD Sales],[last MTD Sales])
and you can use option in Matrix Switch Value to rows