-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 30-
(Excel formulas also welcome for Power Query Challenges)
– This week is for FIFA world cup challenges –
Insert a hyphen ( i.e. - character) after year, country name and striker’s name.
Remove parentheses.
For Power Query solutions only (not for Excel formulas) - All accented letters (diacritics) should be converted to English equivalents. Hence á will be converted to a. For purpose of scoping, you can assume that scope is limited to only those diacritics which are appearing in the source data.
Download Practice File - https://lnkd.in/dTaF_BjN
(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