Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 7 | |
| 6 |