-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 36-
(Excel formulas also welcome for Power Query Challenges)
There are two tables. For second table, against Emp ID, populate the names of employees.
N* - Emp ID starts with N and followed by 0 and more characters: 1* = 1246, 1234
*N - Emp ID finishes with N and preceded by 0 and more characters. *8 = 5628
N OR N - N can be found anywhere within Emp ID
3 = 1234, 9034
3 = 1234, 9034
Download Practice File - https://lnkd.in/dM8fhg5r
(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