Forum Discussion
Create a date custom column by file date
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.
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 Thanks a lot, that worked just fine!