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. 

    • Sean's avatar
      Sean
      Community Champion
      9 years ago

      danielH

       

      Looking at the picture you posted above it seems in both tables the Measures work as intended.

       

      Can you explain and show what goes wrong and where? What results do you expect?

      • danielH's avatar
        danielH
        Helper I
        9 years ago

        Yeah it took me a while to see it but now i understand. :smileysurprised::smileysurprised:

         

        looking properly at the results the first figure seems fine since all of the data is on 2017. 

         

        now on the second figure, i have data from 2016,2017,2018.

                          The total of the second figure is the YTD value of the date 2018. not the total of the complete data. 

                          i am obtaining YTD values per year, which is actually correct as you say. i guess what i am looking for is added values of                     the complete dataset not just per year.

         

        therefore a Line chart for example goes up and in every year end down then up again. 

         

         

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Why we need specify the FY end? And what will be the format of the year end? Or why it is should be "06/30"?

    Thanks,