Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
How to create all possible combinations of the values "WL" "CT," "CL," "AH," and "KH" using the M query in Power BI
Solved! Go to Solution.
tbl = #table({"a"}, {{"CWL,"}, {"CTT,"}, {"WCL,"}, {"AHU,"}, {"KYH"}}),
comb = Table.AddColumn(tbl, "b", each tbl),
z = Table.ExpandTableColumn(comb, "b", {"a"}, {"b"})
tbl = #table({"a"}, {{"CWL,"}, {"CTT,"}, {"WCL,"}, {"AHU,"}, {"KYH"}}),
comb = Table.AddColumn(tbl, "b", each tbl),
z = Table.ExpandTableColumn(comb, "b", {"a"}, {"b"})