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...
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi elf_ranger91,

 

In your scenario, please check the syntax of TOTALYTD() function firstly:

 

TOTALYTD(<expression>,<dates>[,<filter>][,<year_end_date>]) 

 

The fourth parameter needs to be “A literal string with a date that defines the year-end date. The default is December 31.” You can try the modify the DAX like below:

 

YTD Revenue FY16 CLP = TOTALYTD(SUM('FY16 Journal Details'[Monto FY16 CLP]);'FY16 Journal Details'[Effective Date];'Account FY16'[ISG1]="REVENUE";"9/30")

 

Best Regards,
Qiuyun Yu