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 all,
I've read several posts on this but for some reason I can't get it right - I've tried grouping and a few different formulas.
Using the sample table below, I would like "Rating ID" 1 and 3 removed since they were replaced by newer ratings
Rating ID | Customer ID | Date Updated | Rating |
1 | 1729 | 1/15/2021 | 3 |
2 | 1520 | 1/15/2021 | 1 |
3 | 1103 | 1/15/2021 | 3 |
4 | 1639 | 1/15/2021 | 5 |
5 | 1568 | 1/15/2021 | 2 |
6 | 1729 | 2/1/2021 | 2 |
7 | 1774 | 2/1/2021 | 3 |
8 | 1902 | 2/1/2021 | 4 |
9 | 1103 | 2/1/2021 | 4 |
10 | 1211 | 2/1/2021 | 3 |
Thanks in advance!
Solved! Go to Solution.
I figured it out with this video: Power BI Remove Duplicate Records And Keep Most Recent - YouTube
If anyone else has the same issue, you need to add Table.Buffer to the query before you sort by date and remove dups
I figured it out with this video: Power BI Remove Duplicate Records And Keep Most Recent - YouTube
If anyone else has the same issue, you need to add Table.Buffer to the query before you sort by date and remove dups
are you wanting to filter your table or create a measure? what is your expected results? Do you want this filtered out the dataset or just not reported on?
Proud to be a Super User!
Removed from the dataset. I don't want to see it in the data table at all
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |