The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"})