-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 60-
(Solution in any language also welcome for Power Query Challenges)
Generate the Result table from Problem table.
- The items may appear with or without s at the end. Ex - Monitor & Monitors
- If an item is used, “Used” will appear following the item
- If an item is new, then either “New” appears or nothing appears following the word.
Ex. - 1 Headset / 3 Monitor Used - Here Headset will be treated as New
Download Practice File - https://lnkd.in/dTcU-775
(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 LinledIn Post