-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 21-
(Excel formulas also welcome for Power Query Challenges)
List the names who have won consecutively at least 3 times within a span of 180 days.
Span of 180 days is last win date - first win date in a consecutive streak of wins.
2022-01-15 Y
2022-01-28 N
2022-02-12 Y
2022-03-18 Y
2022-05-12 Y
Here all 3 consecutive wins are within 180 days
2022-05-12 - 2022-02-12 : 89 days (The winning streak of at least 3 consecutive wins start on 2022-02-12 not on 2022-01-15)
2022-01-15 Y
2022-01-28 Y
2022-02-12 N
2022-03-18 Y
2022-05-12 Y
Here, 2022-02-12 N - Breaks at least 3 consecutive criterion
If you may have more than one consecutive streaks of at least 3 consecutive wins, in this case, list any one of them.
2022-01-15 Y
2022-01-28 Y
2022-01-31 Y
2022-02-12 N
2022-03-18 Y
2022-05-12 Y
2022-06-08 Y
2022-06-28 Y
Here, there are 2 streaks of consecutive wins
Streak 1
2022-01-15 Y
2022-01-28 Y
2022-01-31 Y
Streak 2
2022-03-18 Y
2022-05-12 Y
2022-06-08 Y
2022-06-28 Y
List either of them. My preference would be Streak 1.
Download Practice File - https://lnkd.in/djWnzM4q
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #data, #analytics, #businessintelligence, #finance
Excel Bi’s LinkedIn Post