Power Query - Dynamic Coalesce multiple columns
Ever so often you'll find datasets that require logic to coalesce various columns into one Column. In this tutorial video i show a basic use can and how you can implement dynamic coalesce with list and record mquery functions.
#data #dataanalytics #mquery #m #powerbi #powerbidesktop #powerquery
links
table.Addcolumn
https://learn.microsoft.com/en-us/pow...
List.Last
https://learn.microsoft.com/en-us/pow...
List.RemoveNulls
https://learn.microsoft.com/en-us/pow...
Record.toList
https://learn.microsoft.com/en-us/pow...
record.selectfields
https://learn.microsoft.com/en-us/pow...