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

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
1 year ago

Anonymous 

Corrected DAX Measure:
YTD AC =
CALCULATE(
SUM('Append'[Value]), 
'Append'[view] = "actuals", 
DATESYTD('FinDate'[Date])
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Sorry I tried this, but I still get the whole year, rather than until the current month.