-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 57-
(Solution in any language also welcome for Power Query Challenges)
Insert new rows for Groups to make row count for all groups equal. Seq for new rows will be n.1, n.2…where n is seq for the previous row.
B appears 4 times which is the maximum. Hence, all groups need to appear 4 times.
A already has 2 rows having Seq 1 & 2. Hence, 2 new rows need to be inserted to make count equal to 4 for Group A and their Seq will be 2.1 & 2.2.
Download Practice File - https://lnkd.in/d6Hz-Ucp
(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, #python, #r
Excel BI’s LinkedIn Post