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,
I'm using a folder to import files to PowerBI.
I used the information given on this forum to solve the problem of importing xlsx files
http://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-2/>
My files are monthly tial balance that I saved as 20160131.xlsx, 20160229.xlsx, etc
I would like to add a new column to have the date retrieved from the file name.
I saw other way with csv files, tried it, but it's not working.
Thank you for your help
Hello,
when you query From Folder, you have column [Name] in query editor. Left to cut it on pieces with help of functions Text.Start, Text.End, Text.Range.
formula for "20160229.xlsx"
#date( Number.From( Text.Start( [Name], 4 ) ),
Number.From( Text.Range( [Name], 4, 2 ) ),
Number.From( Text.Range( [Name], 6, 2 ) )
)
BR,
Ivan
Hi IvanBond,
I tried your solution, but I was not able to make it work.
I selected the 8 first digits ans it worked.
Then I change the format to dates.
Thank you for your help.
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.