Forum Discussion
Comparison- current month vs previous month
- Anonymous9 years ago
Sure there is a way! :-)
You can use DAX to creat the appropriate measures to show in your matrix. See some example here: https://powerbi.tips/2016/07/measures-month-to-month-percent-change/.
But first you need to make sure the Date column is of Date data type - you need this in order to use Time Intelligence functions in DAX and to allow Power BI to deal with time hierarchy.
Hope that helps.
Cheers,
Pawel
- Anonymous9 years ago
OK, try out this .pbix file and see if the approach used inside fits your need: http://blog.sqlgeek.pl/Download/DAX - Month over Month.pbix.
I used the same DAX function mentioned in the article (PREVIOUSMONTH). And presence of the regions in your data doesn't change much.
Cheers,
Pawel
- Anonymous9 years agoInstead of PREVIOUSYEAR use SAMEPERIODLASTYEAR function.
Hi,
I tried the same with data set i have, and its not working. Could you help me out here if possible?? Have attached the link to PBIX Download
Thanks