Forum Discussion
Excel Pivot table must filter based on the date value in a cell
Dear Team, I want the Pivot table to automatically filter Settled Date based on the Target Date. I expect Settled Date to be greater than or equal to the Target date value in J2. Expected re...
As variant creating PivotTable add data to data model plus add target data to data model as another table.
Create DAX measure
Amt:=VAR target=VALUES(Table1[Target Date] )
RETURN CALCULATE( SUMX( Range,
IF(Range[Settled Date] >= target, Range[Amt ₹], BLANK() ) ))