none
Fiscal Year To Date RRS feed

  • Question

  • Hi all,

    I’m trying to create a PowerPivot report with a calculated measure. I created a YTD measure but how to create a Fiscal YTD?

    Current DAX =TotalYTD(count(ChangeControl[RequestID]), DimTime[Date], All(DimTime))

    There is table named DimTime with Five columns: Data, Month, Year, Fiscal Year, Fiscal Month。 Could you let me know the formula for Fiscal Year To Date?

    Regards,

    SSAS_User

    Thursday, August 4, 2011 3:46 AM

Answers

All replies