Calculate Same Period Last Year and Same Period Last Month

[KRISH80]

Hi All,

Can you kindly help me with the DAX to calculate wins for Same Period Last Year and Same Period Last Month ?

My data resides in 2 talbles. Last Year Data in table "Historical Data" and This Years Data in "Funnel". I do have a Dynamic calendar in my power bi report.

Thanks in advance !

Krishna

[Pragati11 · Accepted solution]

Hi @KRISH80 ,

For Same Period Last Year use the following DAX:

https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

For same period last month, refer the following post:

https://community.powerbi.com/t5/Desktop/Compare-data-with-previous-period-last-month/td-p/90426

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati