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

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
1 year ago

Hi, Anonymous 

try below measure 

MEASURE =
CALCULATE (
    [value],
    'Append'[view] = "actuals",
    keepfilter ( 'FinDate'[Date] < TODAY () )
)



Best Regards,
Dangar

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.