Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
I am trying to follow the instruction in the following link Solved: Removing duplicates - Microsoft Power BI Community
in an attempt to remove duplicates (CQTitle) based on the date (DteofCQ).
Everytime I attempt to add a custom column (as instructed in the link) I get the 'yield' sign.
Is this a delegation error or some other type of correctable error?
Solved! Go to Solution.
Resolved. The proper table name was Sorted Rows, and need to be written with quotes:
= Table.AddColumn(#"Sorted Rows", "Most Recent Docs", each let MostRecentDate = [DteofCQ] in "Sorted Rows"([All Rows],each[DteofCQ] = MostRecentDate))
Resolved. The proper table name was Sorted Rows, and need to be written with quotes:
= Table.AddColumn(#"Sorted Rows", "Most Recent Docs", each let MostRecentDate = [DteofCQ] in "Sorted Rows"([All Rows],each[DteofCQ] = MostRecentDate))
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 22 | |
| 21 | |
| 20 | |
| 19 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 52 | |
| 37 | |
| 31 | |
| 27 |