help need with dax (urgent)

[Nihed]

Hello,

I have an Excel table and I have to calculate the following indicators:

someone a little helped me please . I share with you the link with the table urgent please 🙏🙏🙏🙏🙏

The Link pbix:     https://we.tl/t-mMIvUg3zFG 

[Icey]

Hi @Nihed ,

---

---

What is your "last month" based on? Today in calendar or just the current row in your table? For example,

Index	Date	Last Month 1	Last Month 2 (Today is 12/22/2021)
1	Jan 2021		Nov 2021
2	Feb 2021	Jan 2021	Nov 2021
3	Mar 2021	Feb 2021	Nov 2021

In addition, how do you want to show your final result? In which visualization?

Best Regards,

Icey

[amitchandak]

@Nihed , with help from date table and time intelligence you can do that

examples

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 year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))

or

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

refer if needed

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA