Forum Discussion
Comparing values to previous months
Hi, I am wondering whether it is possible to achieve this and display as a table. I have a table that displays client number by month. I then want to add new measures that calculates the d...
Please see the attached sample file. You would not need to create a measure for every month; just for the relative month.
amitchandak
Super User
Super UserAnonymous , create your measure and then with help from time intelligence have measure like
Year behind Sales = CALCULATE([Measure],dateadd('Date'[Date],-1,Year))
6 Months behind Sales = CALCULATE([Measure],dateadd('Date'[Date],-6,Month))
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s