Forum Discussion
Bian
Helper II
4 years agoSemi-additive max date
Hi, I have used Alberto and Marcos DAX pattern for Semi-additive calculations Semi-additive calculations – DAX Patterns Primaraly the DAX code to calculate Balance per customer. I need to add ...
- 4 years ago
So something like this?
Customers Lost = VAR EndDate = DATE ( 10, 30, 2021 ) // Or from filter context VAR MaxChangeDates = ADDCOLUMNS ( SUMMARIZE ( Subscription, Customers[Name] ), "@MaxChangeDate", CALCULATE ( MAX ( Subscription[ChangeDate] ) ) ) VAR AddEndDateCol = ADDCOLUMNS ( MaxChangeDates, "@MaxEndDate", CALCULATE ( MAX ( Subscription[EndDate] ), TREATAS ( { @MaxChangeDate }, 'Date'[Date] ) ) ) RETURN COUNTROWS ( FILTER ( AddEndDateCol, [@MaxEndDate] = EndDate ) )( ^^ Not tested but hopefully gives an idea for the logic, at least.)
AlexisOlson
Super User
4 years agoCan you give some example data and desired output? It's hard to follow exactly what you're asking for in the abstract.