Retrieve the date in the excel file name

[Anonymous]

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

[vicky_ · Accepted solution]

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...

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.