Solved: power query

Anonymous · ‎12-05-2023

How to create all possible combinations of the values "WL" "CT," "CL," "AH," and "KH" using the M query in Power BI

AlienSx · ‎12-05-2023

tbl = #table({"a"}, {{"CWL,"}, {"CTT,"}, {"WCL,"}, {"AHU,"}, {"KYH"}}),
comb = Table.AddColumn(tbl, "b", each tbl),
z = Table.ExpandTableColumn(comb, "b", {"a"}, {"b"})

View solution in original post

AlienSx · ‎12-05-2023

tbl = #table({"a"}, {{"CWL,"}, {"CTT,"}, {"WCL,"}, {"AHU,"}, {"KYH"}}),
comb = Table.AddColumn(tbl, "b", each tbl),
z = Table.ExpandTableColumn(comb, "b", {"a"}, {"b"})