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.
Giving Mr. Beug all the credit for his work in the two year old post below, I have a similar issue. My first attempt at achieving my goal is below.
My need: Remove ALL Duplicate titles of four out of 20 types of CQTitles, displaying only the most recent of those four in the table items and graph tallies. All training documents are in the database. All certification should appear (since there are no duplicates of those docs). Only the most recent qualifications should appear, even if there may be duplicates in the data set.
The four CQTitles for which no duplicates should appear; rather only the most recent: Medical, Live Fire Refresher, Self-Contained Breathing Apparatus Fit Test
let
Source = SharePoint.Tables("https://SiteName/", [ApiVersion = 15]),
#".........." = Source{[Id=".........."]}[Items],
#"Renamed Columns" = Table.RenameColumns(#"..........",{{"ID", "ID.1"}}),
#"Extracted Date" = Table.TransformColumns(#"Renamed Columns",{{"DteofCQ", DateTime.Date, type date}}),
#"Sorted Rows" = Table.Sort(#"Extracted Date",{{"DteofCQ", Order.Descending}}),
#"Buffer Table" = Table.Buffer(#"Sorted Rows")
in
#"Buffer Table"
Solved! Go to Solution.
@Anonymous , This case has been explanied here. See if this can help
https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/
https://www.youtube.com/watch?v=rqDdnNxSgHQ
@Anonymous , This case has been explanied here. See if this can help
https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/
https://www.youtube.com/watch?v=rqDdnNxSgHQ
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |