Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |