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.
Hello forum members,
Can someone explain me how te add a column with the folder names to my PowerBI table?
Thanx in advance,
Loek
Solved! Go to Solution.
Hi @loekvs ,
We can edit the steps after Rename column name as below. M code for your reference as well.
let Source = Folder.Files("D:\Case\New folder"), #"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true), #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])), #"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}), #"Filtered Hidden Files2" = Table.SelectRows(#"Renamed Columns1", each [Attributes]?[Hidden]? <> true), #"Invoke Custom Function2" = Table.AddColumn(#"Filtered Hidden Files2", "Transform File (2)", each #"Transform File (2)"([Content])), #"Expanded Transform File" = Table.ExpandTableColumn(#"Invoke Custom Function2", "Transform File", {"Date", "cat", "Sales"}, {"Transform File.Date", "Transform File.cat", "Transform File.Sales"}), #"Removed Other Columns" = Table.SelectColumns(#"Expanded Transform File",{"Folder Path", "Transform File.Date", "Transform File.cat", "Transform File.Sales"}) in #"Removed Other Columns"
Hi @loekvs ,
We can edit the steps after Rename column name as below. M code for your reference as well.
let Source = Folder.Files("D:\Case\New folder"), #"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true), #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])), #"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}), #"Filtered Hidden Files2" = Table.SelectRows(#"Renamed Columns1", each [Attributes]?[Hidden]? <> true), #"Invoke Custom Function2" = Table.AddColumn(#"Filtered Hidden Files2", "Transform File (2)", each #"Transform File (2)"([Content])), #"Expanded Transform File" = Table.ExpandTableColumn(#"Invoke Custom Function2", "Transform File", {"Date", "cat", "Sales"}, {"Transform File.Date", "Transform File.cat", "Transform File.Sales"}), #"Removed Other Columns" = Table.SelectColumns(#"Expanded Transform File",{"Folder Path", "Transform File.Date", "Transform File.cat", "Transform File.Sales"}) in #"Removed Other Columns"
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.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |