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...
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.