Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi once again,
How do you recommend to remove an older version of a record. I plan to use the file created date as the time stamp to tell which record is newer.
Here's a dummy data:
Color | Shape | Material | Stored |
Red | Circle | Wood | 7/2/2017 |
Red | Circle | Metal | 7/2/2017 |
Red | Circle | Wood | 7/1/2017 |
Yellow | Circle | Wood | 7/4/2017 |
So the plan is to remove record #3 because it is an older version of record #1, the "Store" column should tell when it was stored.
Solved! Go to Solution.
In power query (get data) sort by the date column descending. Then select all columns except date and select remove rows\remove duplicates.
In power query (get data) sort by the date column descending. Then select all columns except date and select remove rows\remove duplicates.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |