topic Re: Consecutive days of missed appointments in DAX Commands and Tips

Consecutive days of missed appointments

BEB2023 — Mon, 25 Sep 2023 15:32:08 GMT

Hi There,

I am trying to get a measure that counts the last consecutively missed appointments in a dataset that looks like in the screenshot below. Essentially, the measure should count all missed appointments (MissedAppt = Yes) since the last appointment that was not missed (MissedAppt = No). I appreciate any help you can provide with this.

Regards

Re: Consecutive days of missed appointments

sjoerdvn — Mon, 25 Sep 2023 15:59:26 GMT

something like this I Guess

consecutively missed appointments for ID= VAR lnmap = CALCULATE(MAX(Table[Date]),Table[MissedAppt]="No") VAR smap = IF(ISBLANK(lnmap),DATE(1900,1,1),lnmap) RETURN IF(HASONEVALUE(Table[ID],CALCULATE(COUNTROWS(Table), Table[Date]>smap, Table[MissedAppt]="Yes"))

Re: Consecutive days of missed appointments

ThxAlot — Mon, 25 Sep 2023 18:57:52 GMT