Forum Discussion
Retrieve the date in the excel file name
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.
Super UserYou 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.