Forum Discussion
Line Percentage MoM completion Comparison
Kostas , You can have measure for current and last month and then use
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 = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
this month = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
diff %= divide([this month]-[last month], [last month])
and use this measure with month on axis and year as legend and you have use those from date table
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
Hello amitchandak and thanks for your reply.
How the date within the calculation is connected with the completion date in the table above?
Sorry I am not sure how that works.
Also, in the last calculation you are using the Previous and This month calculations, how should I utilise the first two measures?