Adding file name & path as a column attribute

[Anonymous]

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

Commercials_2019.07.xlsx
Commercials_2019.08.xlsx
Commercials_2019.09.xlsx

The table of data in each XLSX is similar to the below. I'd like to be able to add a File Path column to the tables:

DocId	Author	Author Department	File Path
400029	Jimmy James	Sales	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.07.xlsx
400029	Jimmy James	Sales	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.07.xlsx
400029	Kelly kellyson	Finance	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.07.xlsx
400029	Kelly kellyson	Finance	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.08.xlsx
400029	Peter Peterson	Services	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.08.xlsx
400030	Peter Peterson	Services	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.08.xlsx
400030	Petra Petrason	C-Suite	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030	Sarah Sarahson	Finance	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030	Sarah Sarahson	Finance	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030	Jimmy James	Sales	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030	Kelly kellyson	Finance	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030	Kenny Kennyson	Sales	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030	Kenny Kennyson	Sales	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030	Mark Markson	Sales	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030	Mark Markson	Sales	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400035	Michael Hutchens	Services	<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx

This would enable me to add File Path to a slicer, to slice data based on month.

Any assistance would be appreciated.

[v-lili6-msft]

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

[Anonymous]

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

---