Calculate the Difference in percentage

[HishamAT]

how to calculate the difference between current month in the current year and the previous year with the same month in DAX ? 

[TomMartens · Accepted solution]

Hey @HishamAT ,

I recommend reading this article: https://www.daxpatterns.com/time-patterns/
This article contains almost everything what you need to know about time/date calculations using DAX.

Hopefully, this gets you started.

Regards,

Tom

[RajaCSN · Accepted solution]

You can use the Dax function: Sameperiodlastyear to achieve this. Though the image is not showing the difference between a monthly value (on two given years), that can be done with a simple formula. (Diff = This year value - last year value). Hope this helps.Dax function: Sameperiodlastyear

[TomMartens · Accepted solution]

Hey @HishamAT ,

I recommend reading this article: https://www.daxpatterns.com/time-patterns/
This article contains almost everything what you need to know about time/date calculations using DAX.

Hopefully, this gets you started.

Regards,

Tom