The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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.
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.
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |