Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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))
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 47 | |
| 45 | |
| 33 | |
| 33 | |
| 30 |
| User | Count |
|---|---|
| 136 | |
| 116 | |
| 58 | |
| 58 | |
| 56 |