Forum Discussion
power query
How to create all possible combinations of the values "WL" "CT," "CL," "AH," and "KH" using the M query in Power BI
tbl = #table({"a"}, {{"CWL,"}, {"CTT,"}, {"WCL,"}, {"AHU,"}, {"KYH"}}), comb = Table.AddColumn(tbl, "b", each tbl), z = Table.ExpandTableColumn(comb, "b", {"a"}, {"b"})
1 Reply
tbl = #table({"a"}, {{"CWL,"}, {"CTT,"}, {"WCL,"}, {"AHU,"}, {"KYH"}}), comb = Table.AddColumn(tbl, "b", each tbl), z = Table.ExpandTableColumn(comb, "b", {"a"}, {"b"})