power query

[Anonymous]

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

[AlienSx · Accepted solution]

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