Forum Discussion

elf_ranger91's avatar
elf_ranger91
Frequent Visitor
9 years ago

TOTALYTD incorrect values

Hi guys I hope someone can help me out here.   I´m having some difficulty with the TOTALYTD function. Here is what I have written in my DAX formula:    YTD Revenue FY16 CLP = TOTALYTD(SUM('FY16 J...
  • danielH's avatar
    danielH
    Helper I
    9 years ago

    I have the same issue. 

    what is weird is that a have a tile which works, and in the other tile doesnt. with basically same input, diferent Data sources. 

    is there a solution for this ? 

     

     

    • Sean's avatar
      Sean
      Community Champion
      9 years ago

      danielH

      Can you post the formula of the Measure you are using?

      Are you specifying the fiscal year end? (as mentioned above)

      For example if your FY ends June 30

      MEASURE 1

      YTD Total =
TOTALYTD ( SUM ( Table[Column] ), 'CalendarTable'[Date], "06/30" )

      or alternatively

      MEASURE 2

      YTD Total ALT =
CALCULATE ( SUM ( Table[Column] ), DATESYTD ( 'CalendarTable'[Date], "06/30" ) )

       

      Good Luck! :smileyhappy:

      • danielH's avatar
        danielH
        Helper I
        9 years ago

        Sure, I am using for the first one ( the one that comes out correct ) : 

         

        YTD USERS = TOTALYTD(SUM('Planner LAN International'[User]);'Planner LAN International'[Enddatuminkl. First Day Support])

         

        the second one ( the one woth the error )  : 

         

        T YDT Users = TOTALYTD(SUM(LOCATION_LIST_ScheduleDates[Users]);LOCATION_LIST_ScheduleDates[LAN planned end])

         

        To answer your quiestion, no i am not using specifying a year end. but if i do specify one, as your example 

         

        T YDT Users = TOTALYTD(SUM(LOCATION_LIST_ScheduleDates[Users]);LOCATION_LIST_ScheduleDates[LAN planned end];"06/30")

         

        i do see a change at the result, yet again instead of 230 is 2528.

        i am compleatly lost, i have no ide what i am missing.

         

        thanks, one step closer but not quite there yet.