-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 20-
(Excel formulas also welcome for Power Query Challenges)
There are two rows per Emp ID which are from two different sources.
You need to list down Emp IDs and then column names which are not matched against those Emp IDs…
For example, in rows 4 & 5 (Emp ID - 252591), weights are 70 & 71. And cities are Sadler and Sadlar. Hence, Weight, City are the mismatched columns for rows 4 & 5.
Don’t consider first 2 columns for mismatch as they are not mismatched.
Download Practice File - https://lnkd.in/danPEbuq
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerbi, #powerquery, #dax, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #powerbideveloper, #powerbidesktop, #powerbitips, #powerbitricks, #excel, #excelchallenge, #excelproblem, #powerpivot
Excel BI’s LinkedIn Post