Forum Discussion
Filter Context with YTD Calculation
I am struggling to come up with a DAX Formula to help me with creating a YTD column based on 1 condition. I have the table [Actuals-Plan] which has the following relevant columns - Amount: $ amo...
Thank you very much! The second link put me in a much better position, but i am not understanding why I am still getting datafor "Plan", when i specifically filtered it out in my DAX Formula.
TEST =
Var _Date= MAX('Actuals-Plan'[Date])
Var _Table= Filter(ALLSELECTED('Actuals-Plan'),'Actuals-Plan'[Date]<=_Date && 'Actuals-Plan'[PlanActual]="Actual")
RETURN
SUMX(_Table,'Actuals-Plan'[Amount])
Here is the result. I only want to show the column "Actuals".