Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
Create a list in Power Query it's easy {[col1], [col2], [col3])
But how do you create a list when you have a variable number of columns ?
In my case, my headers' name are simple, it's [1], [2], [3], ..... But I don't know if I will have 5 columns or 50.
In that case, how to you convert the values of these columns into a List ?
Solved! Go to Solution.
You may change it as follows.
Record.ToList(Record.RemoveFields(_, {"Column1", "Column2"}))
You may simply add a custom column.
Record.ToList(_)
Ok Thanks Sam,
But if want all the columns except the first column or, like in my case, exclude the first 4 columns from your List. In that case, what do you do ?
You may change it as follows.
Record.ToList(Record.RemoveFields(_, {"Column1", "Column2"}))
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
108 | |
92 | |
67 |
User | Count |
---|---|
167 | |
130 | |
129 | |
94 | |
91 |