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

Mahesh0016's avatar
Mahesh0016
Super User
1 year ago
Anonymous Please try below one

YTD AC =
CALCULATE(
                      TOTALYTD( [Total View], 'FinDate'[Date], 'FinDate'[Date]<TODAY() )
                      , 'Append'[view]="actuals"
        )
       

 



Anonymous  Thank You!