Forum Discussion

Adlu's avatar
Adlu
Frequent Visitor
3 years ago

Measure calculating change + filter

I have a table like the one below, filtered by Nov, Dec, and 2021, 2022: Now, the "Change" in November 2022 is calculating October 2022 vs November 2022. How to adjust the measure to make it b...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Adlu . Sales vs 11 month before sales

 

 

example

 

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

 

11 Months behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-11,Month))

 

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
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