-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 47-
(Solution in any language also welcome for Power Query Challenges)
Count the process groups as given. A process group is a continuous set of processes.
Hence, Process 1, Process 2 is a process group. But Process 1, Process 3 is not a process group as processes 1 & 3 are not continuous.
Similarly, Process 1, Process 2, Process 4 is not a process group as this is not continuous.
Hence only process group possible in below set of data is
Process 1
Process 1, Process 2
Process 1, Process 2, Process3
Process 1, Process 2, Process 3, Process4
Download Practice File - https://lnkd.in/d4JiEtvV
(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