Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |