Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

YTD

I have put this dax together.   YTD AC = TOTALYTD( sumx(FILTER('Append','Append'[view]="actuals"),[Value]), 'FinDate'[Date], 'FinDate'[Date]<TODAY())   I am getting the same result as    ...
ytd dynamic
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

    I created a sample pbix file(see the attachment), please check if that is what you want.

    YTD AC = 
CALCULATE (
    SUM ( 'Append'[Value] ),
    FILTER (
        'Append',
        'Append'[view] = "actuals"
            && YEAR ( 'Append'[Date] ) = YEAR ( TODAY () )
            && 'Append'[Date] <= TODAY ()
    )
)

    Best Regards

Laxmanjatoth's avatar
Laxmanjatoth
Icon for Resolver I rankResolver I
1 year ago

Anonymous , use the below measure 

the reason why iam choosing this measure , if it is more 1 filters then you have to use datesytd function forperfamnace . please check the below one 
YTD =
CALCULATE(
SUM('Append'[Value]),
'Append'[view] = "actuals",
DATESYTD('FinDate'[Date])
)
or use below one 
YTD AC =
CALCULATE(
SUM('Append'[Value]),
'Append'[view] = "actuals",
DATESYTD('FinDate'[Date])
)


please accept if my measure will works