Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
142 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |