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 have a daily data source file that requires accessing, however each the name of the source file itself is different with a new datetime stamp appended at the end:
For example each the file has the following name followed by the YYYY-MM-DD-HH-MM-SS:
DELIVERY ADDRESS & TYPE PP32024-02-04-14-25-00
DELIVERY ADDRESS & TYPE PP32024-02-05-14-25-08
DELIVERY ADDRESS & TYPE PP32024-02-06-14-25-07
Is there a way of using a "contains" to reference the first part of the source file so that it is dynamic for all future files?
If so, how do I write this code?
Thanks!
@RD_PowerBI24 Load the files as a folder, and there before expand of binary data you can filter data using contains
Thanks Amit. However, this didn't seem to work for the text.contains function or I was doing it wrong.. As it is a cumulative file of records I found another solution which works and allows the new file to replace the previous day's one without explicit reference.
User | Count |
---|---|
77 | |
76 | |
36 | |
31 | |
29 |
User | Count |
---|---|
93 | |
79 | |
57 | |
48 | |
48 |