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 |
|---|---|
| 52 | |
| 41 | |
| 32 | |
| 26 | |
| 24 |
| User | Count |
|---|---|
| 132 | |
| 118 | |
| 57 | |
| 45 | |
| 43 |