Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
i am using this function:
Excel.CurrentWorkbook(){[Name="Table322"]}[Content]
ti get full table.
How can i get specific columns, like "Col1" and "Col2" from this function?
Best,
Jacek
Solved! Go to Solution.
Hi @jaryszek ,
Just wrap the whole table reference in a Table.SelectColumns function:
= Table.SelectColumns(
Excel.CurrentWorkbook(){[Name="Table322"]}[Content],
{"columnName1", "columnName2"}
)
Pete
Proud to be a Datanaut!
Hi Guys,
one more question, can provide instead of column name, column index?
Best,
Jacek
Hi @jaryszek ,
Just wrap the whole table reference in a Table.SelectColumns function:
= Table.SelectColumns(
Excel.CurrentWorkbook(){[Name="Table322"]}[Content],
{"columnName1", "columnName2"}
)
Pete
Proud to be a Datanaut!
Thank you !
Indeed.
@jaryszek This is the same function that will be used if you use the Choose Columns button in the ribbon.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.