0

How can I add a condition to the below dax to identify the gap between 202209 and 202305 and reset the count?

-- Calc Column
Active_records = 
var _GP = Table[GP]
var indv_id = Table[ID]
var _end_date = Table[DATE]
var _DATE = EOMONTH(_end_date,-24)+1

VAR _COUNT = RANKX ( 
        FILTER (ALL(Table),
            Table[GP] = EARLIER(Table[GP])
            && Table[ID] = EARLIER(Table[ID])
            && Table[MALES_UNDER_35] = EARLIER(Table[MALES_UNDER_35])
            && Table[DATE] >= _DATE
            && Table[DATE] <= _end_date
        ),        
        Table[DATE],
        ,
        ASC,
        Dense
    )
 RETURN 
 
_COUNT

enter image description here

ended up adding to my sql instead of PBI. Reset DENSE_RANK() OVER partition by where just one row is different

SamR
  • 517
  • 3
  • 10
  • 24

0 Answers0