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
learn.microsoft.com/en-us/pow...
List.Last
learn.microsoft.com/en-us/pow...
List.RemoveNulls
learn.microsoft.com/en-us/pow...
Record.toList
learn.microsoft.com/en-us/pow...
record.selectfields
learn.microsoft.com/en-us/pow...