Forum Discussion
Solved
After combining my files how do I update the data when a change happens to a unique identifier?
Hello All! I have 19 txt files that are in the same folder labelled Data. Each of these files need to be its own table in Power BI. Everyday a new set of 19 txt files are dropped in the Data folder ...
Hi nebhatt
You filter on the max date, this will only show the record with the latest date.
Please refer to my post https://community.fabric.microsoft.com/t5/Power-Query/Sorting-by-most-recent-date/m-p/3397167/highlight/true#M110399
Thanks
Joe
If this post helps, then please Accept it as the solution
JoeBarry
Solution Sage
Solution SageHi nebhatt
You filter on the max date, this will only show the record with the latest date.
Please refer to my post https://community.fabric.microsoft.com/t5/Power-Query/Sorting-by-most-recent-date/m-p/3397167/highlight/true#M110399
Thanks
Joe
If this post helps, then please Accept it as the solution