sw123Helper III2 years agoSolvedUse only last value Hi, I have a table that looks like this: Date Item Amount Event 14.5.2024 A 2607,09 A 14.5.2024 A 2285,214 B 14.5.2024 A 2090,322 C 14.5.2024 B 9750 A 14.5.2024 ...Show Moreddpl2 years agosw123 Cerate Measure as per below and use as filterMeasure = SWITCH( TRUE(), MAX('Table (4)'[Date]) = MAX('Table (4)'[Date]) && MIN('Table (4)'[Event]) = "A", 1,0 )
ddpl2 years agosw123 Cerate Measure as per below and use as filterMeasure = SWITCH( TRUE(), MAX('Table (4)'[Date]) = MAX('Table (4)'[Date]) && MIN('Table (4)'[Event]) = "A", 1,0 )
ddpl2 years agosw123 Cerate Measure as per below and use as filterMeasure = SWITCH( TRUE(), MAX('Table (4)'[Date]) = MAX('Table (4)'[Date]) && MIN('Table (4)'[Event]) = "A", 1,0 )
ddplSolution Sage2 years agosw123 Cerate Measure as per below and use as filterMeasure = SWITCH( TRUE(), MAX('Table (4)'[Date]) = MAX('Table (4)'[Date]) && MIN('Table (4)'[Event]) = "A", 1,0 )
Related contentClosing valueremove duplicate value within a rowIF Negative valueHandling Null ValuesDAX for calculating retroactive values
