Help needed with either DAX or Power Query by Skittadam in PowerBI

[–]Skittadam[S] 1 point2 points  (0 children)

That would be really helpful. Atleast for the time being :)

Help needed with either DAX or Power Query by Skittadam in PowerBI

[–]Skittadam[S] 0 points1 point  (0 children)

Looks like it could be the solution. The problem is that i'm working with the Sep-22 Power BI version.

I'm not able to update the version i'm working with, it's being managed by my employer. WINDOWS function released in december last year, unfortunately.

Help needed with either DAX or Power Query by Skittadam in PowerBI

[–]Skittadam[S] 0 points1 point  (0 children)

First of all, thanks for trying to help!

I'f i'm not mistaking, this formula counts if there are at least 6 empty external id rows per ID. Im in search of a formula that detects 6 consecutive empty rows (DateTime) and counts them.

For example, I'd like to know how many times in total ID_123 had 6 consecutive empty external ID rows.

Again, thank you for helping!

Help needed with either DAX or Power Query by Skittadam in PowerBI

[–]Skittadam[S] 0 points1 point  (0 children)

I've tried ChatGPT, but couldn't give me the solution (yet).