Forum Discussion
Adding file name & path as a column attribute
Hi everyone, I'm hoping someone can assist. I'm using a SharePoint folder as a data source for a report. The folder contains XLSX files that will be added to each month, e.g.: Commercials_2019.06...
hi, Anonymous
You could expand the context of all the xlsx, then extract month value by Split Column in edit queries.
Then use it as a slicer.
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Best Regards,
Lin
Thanks v-lili6-msft - not sure what we mean by the following?
v-lili6-msft wrote:You could expand the context of all the xlsx