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.
Hello,
I have the dataset as mentioned below and I want to remove duplicates based on a column and max date.
input set:
order_id posted_date
12734 5/29/2019
12735 4/16/2019
12734 4/15/2019
12735 4/20/2019
12735 3/18/2019
desired output
order_id posted_date
12374 5/29/2019
12375 4/20/2019
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous
Create a new calculated table:
NewTable = FILTER ( Table1, Table1[posted_date] = CALCULATE ( MAX ( Table1[posted_date] ), ALLEXCEPT ( Table1, Table1[order_id] ) ) )
Hi @Anonymous
Create a new calculated table:
NewTable = FILTER ( Table1, Table1[posted_date] = CALCULATE ( MAX ( Table1[posted_date] ), ALLEXCEPT ( Table1, Table1[order_id] ) ) )
This fixed my issue I was having too! Thanks for this!
Proud to be a Super User!
@AlB ,
Thanks for the response.
There are other columns in the table. I want to filter the duplicates based on order_id and posted_date. Can't it be done from power query or from DAX on the same table?
Thanks
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |