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 |
|---|---|
| 50 | |
| 42 | |
| 36 | |
| 31 | |
| 29 |
| User | Count |
|---|---|
| 129 | |
| 129 | |
| 59 | |
| 48 | |
| 47 |