Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Any one can please help me out the below senario?
I have the data and date tables as marked in SSAS and now i want to caluculate the (TOTALYTD,TOTALMTD,PreviousYTD,PreviousMTD) and which month is starting from (Dec-NOV).
and i have the Fiscal month and fiscal year columns in my date table.
i have used to different senarios to get the result.
Can anyone give the exact the DAX functions for those caluculation?
Thanks,
Kapil
Solved! Go to Solution.
Hi @kapil512,
You can go through these similar threads firstly:
http://community.powerbi.com/t5/Desktop/MTD-Comparison-to-same-period-last-year/td-p/188900
If you are not able to create your own measures, please share some dummy data and clarify the desired results for our analysis.
Best Regards,
Qiuyun Yu
Hi @kapil512,
You can go through these similar threads firstly:
http://community.powerbi.com/t5/Desktop/MTD-Comparison-to-same-period-last-year/td-p/188900
If you are not able to create your own measures, please share some dummy data and clarify the desired results for our analysis.
Best Regards,
Qiuyun Yu
Thank you so much Qieyun.
its worked 😉
Thanks,
Kapil
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |