Forum Discussion
Retrieve the date in the excel file name
hi
i am new to Power BI. i would liek to display in my report the date of the excel file name.. ?
could you please let me know how to do it please?
thank you
You can follow the steps here to grab the name of the file: https://community.fabric.microsoft.com/t5/Desktop/adding-the-file-name-to-a-column-in-power-query/td-p/2125335
And then, to extract the date, you can use Transform > extract > text between delimiters" function in Power Query, and set the start to . and the end to _, which should extract just the numbers representing the date (this obviously depends on the date format of your file, so play around with it)
You can then load that into your report.
1 Reply
vicky_Super User
You can follow the steps here to grab the name of the file: https://community.fabric.microsoft.com/t5/Desktop/adding-the-file-name-to-a-column-in-power-query/td-p/2125335
And then, to extract the date, you can use Transform > extract > text between delimiters" function in Power Query, and set the start to . and the end to _, which should extract just the numbers representing the date (this obviously depends on the date format of your file, so play around with it)
You can then load that into your report.