Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is there a way that I can push the creation date of a file I am using as a datasource to show as a column after I combine the file's binary data?
Thanks
J
Solved! Go to Solution.
Hi @jagostinhoCT,
Please try the solution mentioned in below link to see whether it works in your scenario.
Create a date custom column by file date
Best regards,
Yuliana Gu
Hi @jagostinhoCT,
Please try the solution mentioned in below link to see whether it works in your scenario.
Create a date custom column by file date
Best regards,
Yuliana Gu
IN edit queries under Transform thers is option calld "Fill" which can be used to fill down or up.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks @parry2k.
I could not find how to do it the way you mentioned. I found a workaround, however.
Not entirely sure on the caveats for this but it seems to work. Any thoughts?
Joaquim
hmmm...
I am getting an error....
I understand it might be due to the workaround described above.
You reckon it is fixable?
let
Source = AuditsLog,
#"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1),
#"Kept Errors" = Table.SelectRowsWithErrors(#"Added Index", {"Name", "Extension", "Date accessed", "Date modified", "Date created", "Folder Path", "RevitVersion", "SourceFilePath", "SourceFileName", "DetailLineCount", "FilledRegionCount", "MaskingRegionCount", "TextNoteCount", "SelectedElementCount", "SheetCount", "PurgeableGroupTypeCount", "FileLength", "ElementCount", "JobFolderName", "LiveFiles", "RecordFiles"}),
#"Reordered Columns" = Table.ReorderColumns(#"Kept Errors", {"Row Number", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Folder Path", "RevitVersion", "SourceFilePath", "SourceFileName", "DetailLineCount", "FilledRegionCount", "MaskingRegionCount", "TextNoteCount", "SelectedElementCount", "SheetCount", "PurgeableGroupTypeCount", "FileLength", "ElementCount", "JobFolderName", "LiveFiles", "RecordFiles"})
in
#"Reordered Columns"