Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi everyone,
I daily download a .csv file that has no date reference. I'd like to create a custom column that sets the date by the 'file modified date' (or similar).
any ideas?
Thanks!
Solved! Go to Solution.
Instead of combining binaries, add a custom column with formula =Csv.Document([Content]).
This will give you a table with the file contents, which can be expanded without losing the "date modified".
The "Content" column can be removed after you added the custom column.
OK, this is just a working theory, but if you use a Folder query, you can get the last modified date. So I'm thinking that perhaps creating a custom function where you grabe the "Date Modified" from a folder query wrapped in your function that you could return this back as a value for a custom column in the query. Perhaps @ImkeF has a better way, she is the M code expert.
@Anonymous
Did you try this?
1. get data
2. select folder option
3. specify the path of the file
4. now you can see the file properties and choosethe field you want and add it as column
5. have that column in the slicer
Hi @Anonymous, thanks for your help
I think i'm missing the step where 'i choose the field i want and add it ass column' (and later on, step 5). Usually, when i get a .csv from a folder, i use the 'combine binaries' button, and all of the other columns disappear.
Before combining binaries
After combining binaries
Instead of combining binaries, add a custom column with formula =Csv.Document([Content]).
This will give you a table with the file contents, which can be expanded without losing the "date modified".
The "Content" column can be removed after you added the custom column.
@MarcelBeug, good tip.
My new column is containing all of the info. I mean, it does not split into columns. Any ideas how to overcome this?
My file contains Tab separated info
Thanks
That would be very similar: just replace Csv.Document with Excel.Workbook.
Is there also any way to get modified/created date out of file when the file is stored in the SharePoint?
Iam connecting to it with powerbi using get data "web"
Hi,
I have the same issue.
I would like to display the creation date of an excel file in my report.
Any idea how to read and display it?
Thanks a lot for helping.
Rob
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
105 | |
68 | |
48 | |
42 | |
41 |