Forum Discussion
Solved
Identifying relevant rows
Hi all My dataset records everything, and I am struggling to create something that helps sort it. My dataset is as follows: Cust ID. Status. Date (UK) CST001 E...
Daretoexplore Might be best to have an index column, but you could do it like this:
Column = VAR __Cust = [Cust ID.] VAR __MaxDate = MAXX( FILTER( 'Table', [Cust ID.] = __Cust && [Status.] = "Entered Shop" ), [Date (UK)]) VAR __Result = IF( [Date (UK)] = __MaxDate, 1, 0 ) RETURN __ResultThen for the measure:
Measure = VAR __Cust = MAX('Table'[Cust ID.]) VAR __Table = SUMMARIZE( FILTER('Table', [Column] = 0), [Date (UK)] ) VAR __Result = COUNTROWS( __Table ) RETURN __ResultDaretoexplore Likely need to use >= in the column formula when comparing to __MaxDate instead of =.
Actually Greg_Deckler
Whilst I think about it. It is a 24 hour shop, so if in that example the Entered Shop was on the 7/2/2024 instead of the 8th.l, however the 'Exited Shop' was still on the 8/2/2024. How would the DAX need to be adapted for that.
Daretoexplore Likely need to use >= in the column formula when comparing to __MaxDate instead of =.