In TOTALYTD function is it possible to avoid hard-coding year_end_date?


  • Suppose you have a fiscal year of 9/30. The TOTALYTD function looks like:

      YTD Actual $:=TOTALYTD( [Actual $], 'Date'[Date], ALL('Date'), "9/30")

    But I want to avoid hard coding "9/30", and assuming I have a settings table from where I can get a date with the yearend, I tried this: 

      YTD Actual $:=TOTALYTD ([Actual $], 'Date'[Date], ALL('Date'), DISTINCT( 'Settings'[YearEndDate]))

    I get no errors but it calculates like "12/31". I tried to use Format but with no luck.

    Is there a way to make this work?

    Monday, December 16, 2013 11:56 PM


All replies