Excel BI Power Query Challenge Workout 025

-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 25-
(Excel formulas also welcome for Power Query Challenges)

If in a group of IDs, first occurrence of event Z appears with a category of Temporary, then all Values should be Yes otherwise No.
In 315 - First occurrence of event Z doesn’t have a category of Temporary, hence all values will be No.
In 401 - First occurrence of event Z has a category of Temporary, hence all values will be Yes.

Download Practice File - https://lnkd.in/d3JN27Dj

(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)

#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge

Excel BI’s LinkedIn Post