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...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

If I am breaking down your formula correctly:

 

YTD Revenue FY16 CLP =

 

TOTALYTD(SUM('FY16 Journal Details'[Monto FY16 CLP]); - So the first parameter you are telling it to SUM your [Monto FY16 CLP] field. That's fine.

 

'FY16 Journal Details'[Effective Date]; - Here you are passing in a column of dates. That's fine.

 

'Account FY16'[ISG1]="REVENUE"; - Now you have passed in a filter to only include columns that are REVENUE. This should be fine as long as the tables are related. In theory, somehow your Account table is related to your FY16 Journal Details so you should only be pulling FY16 Journal Details that relate back to an Account that is tagged as "REVENUE", correct?

 

ALL('FY16 Journal Details'[Effective Date])) - This one I don't understand, the fourth parameter should be the specification of an End Date for the year. It looks like instead you are passing it in an entire column of dates which means it will probably just grab the first date.