The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hey ihave the following data
First Name | last name | degree | payment | ID | |
jack | Eden | Eden exapmle.com | bachelor | 250$ | 2160003021 |
lora | Teigen | Teigen example.com | bachelor | 340 | 3160003021 |
jack | Edin | Eden1exapmle.com | bachelor | 600$ | 5160003021 |
jack | Eden | Eden1exapmle.com | bachelor | 500$ | 5160003021 |
how can i assign uniqe ID to the most frequent first name
because i have a lot of misspelled names and i want to unifiedthem
i wrote the following dax column but it i do not know how to add the most frequent first name part
name unique =
VAR same_names =
CALCULATETABLE (
SUMMARIZE ( 'Table1 (2)', 'Table1 (2)'[ID], 'Table1 (2)'[First Name] ),
ALLEXCEPT ( 'Table1 (2)', 'Table1 (2)'[First Name] )
)
VAR ranking = RANKX ( same_names, 'Table1 (2)'[ID],, ASC, DENSE )
VAR blanks = REPT ( UNICHAR ( 8204 ), ranking - 1 )
VAR res = 'Table1 (2)'[First Name] & blanks
RETURN
res
Please HELP and THANK YOU
Instead of ranking by ID ascending, rank by first name descending and grab the entry with rank 1
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |