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

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:

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,