Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Tom_Y
Advocate II
Advocate II

Using a LIST in Column Header/ Expand Table

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

 

 

Tom_Y_0-1701606219452.png

 

1 ACCEPTED SOLUTION
AlienSx
Super User
Super User

@Tom_Y don't use curly brackets. Plain ListOfColumns should work.

View solution in original post

2 REPLIES 2
Tom_Y
Advocate II
Advocate II

Wow, magical!

AlienSx
Super User
Super User

@Tom_Y don't use curly brackets. Plain ListOfColumns should work.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.