The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
This code is working, and generate the table I need. But when I replace {"Project", "SURVEY DATE", "Measure", "Count"} by {ListOfColumns} then it fails. Can anyone help? Thank you very much.
let
Source = #"List of Project",
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandTableColumn(#"Converted to Table", "Column1", {"Project", "SURVEY DATE", "Measure", "Count"}, {"Project", "SURVEY DATE", "Measure", "Count"})
in
#"Expanded Column1"
This is the query for ListOfColumns and it's working on its own.
let
Source = {"Project", "SURVEY DATE", "Measure", "Count"}
in
Source
Solved! Go to Solution.
Wow, magical!