DAX Function for TOTALYTD and TOTALMTD for FiscalYear and FiscalMonth

[kapil512]

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

[v-qiuyu-msft · Accepted solution]

Hi @kapil512,

You can go through these similar threads firstly: 

http://community.powerbi.com/t5/Desktop/Last-YTD-DAX-calculation-by-Fiscal-Year-Leap-Year/td-p/14083...

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 

[v-qiuyu-msft · Accepted solution]

Hi @kapil512,

You can go through these similar threads firstly: 

http://community.powerbi.com/t5/Desktop/Last-YTD-DAX-calculation-by-Fiscal-Year-Leap-Year/td-p/14083...

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 

[kapil512 · Accepted solution]

Thank you so much Qieyun.

its worked 😉

Thanks,

Kapil