Forum Discussion
Solved
How to insert "Date Modified" to "Content" binary in Power Query?
I have loaded multiple files in Power Query. However, when I expand the content column, the "Date Modified" column is not carried over because it is not part of the file contents. I read in another post that it might be possible through "Add Custom Column," but I don't know what the function should look like. Does anyone know how I can transfer the information into my content?
Ok, I figured it out myself, and it's really simple. For those who are interested:
- Simply expand the Content table and load the necessary sheets.
- Now the content of the tables will open, but without the Date Created column.
- To add this column, you need to go to the "Applied Steps" pane on the right side. Power Query has added several entries there. You might need to experiment a bit and delete 1-2 entries, then go back to the overview, and all data from the Content will load, including the Date Created column.
2 Replies
Ok, I figured it out myself, and it's really simple. For those who are interested:
- Simply expand the Content table and load the necessary sheets.
- Now the content of the tables will open, but without the Date Created column.
- To add this column, you need to go to the "Applied Steps" pane on the right side. Power Query has added several entries there. You might need to experiment a bit and delete 1-2 entries, then go back to the overview, and all data from the Content will load, including the Date Created column.
Hi AlexBI ,
Really glad to hear that you've fixed it by youself.
If possible, please accept your own reply as solution. I believe that more people will benefit from it.
Best Regards,
Stephen Tao
