Forum Discussion
How to automatically overwrite the timestamp?
Hello people,
I got probably a easy to answer question, however I am really new to PowerBI so I didn't actually figure out how to do it.
So my PowerBI Report, is using the data from a folder, which will be feeded with excel files probably like once per week. The files have all the same columns. In the files are ShipmentIDs with different Timestamps. I use just one table in PowerBI but form different excel files.
Now my issue:
Lets say in the folder is an old File, where a Shipment ID does not yet have a certain timestamp. But in the week after, there is a new file which actually has this timestamp for that exact same ID. Now in my PowerBI Report I have the ID twice, one with the empty Timestamp and one with the correct one. And I would like to have the ID just once with the new timestamp. I have attached a picture for clarification.
I have tried it with "Merge Queries" in Power Query, however you need two tables for that, and again I only use one table.
I would appreciate some help. Thank you in advance!
2 Replies
Anonymous , you can use "Merge Queries" in your scenario, but with some tricks.
You can first load both the old and new Excel in PowerBI, and then use the "Merge Queries" functionality.
AT this stage, you disable "enable load" for the old table.
Assuming your old data always have blanks in the "loading confirmation" when the update is yet-to-come, finally you can filter the "loading confirmation" column to exclude any blank values.
This should work as you wish. You could provide some sample data/file here in case you need some demostration, or if you find the above cannot achieve what you wish.
Hi johnyip so in the old file there are not only blanks. Some have already timestamps and some not
