Forum Discussion
mina97
Helper III
Helper IIIunique vales based on
i have the following data Fisrt name last name email degree payment ID jack Eden Eden exapmle.com bachelor 250$ 2160003021 lora Teigen Teigen example.com bachelor 340 ...
mina97 , I now get what you wanted in your code.
So, create a calculated column in your table:
name unique = VAR same_names = CALCULATETABLE ( SUMMARIZE ( Specialists, Specialists[ID], Specialists[First_Name] ), ALLEXCEPT ( Specialists, Specialists[First_Name] ) ) VAR ranking = RANKX ( same_names, Specialists[ID],, ASC, DENSE ) VAR blanks = REPT ( UNICHAR ( 8204 ), ranking - 1 ) VAR res = Specialists[First_Name] & blanks RETURN resAnd use this column for the x-axis of your visual:
ERD
Community Champion
Community Championmina97 , I now get what you wanted in your code.
So, create a calculated column in your table:
name unique =
VAR same_names =
CALCULATETABLE (
SUMMARIZE ( Specialists, Specialists[ID], Specialists[First_Name] ),
ALLEXCEPT ( Specialists, Specialists[First_Name] )
)
VAR ranking = RANKX ( same_names, Specialists[ID],, ASC, DENSE )
VAR blanks = REPT ( UNICHAR ( 8204 ), ranking - 1 )
VAR res = Specialists[First_Name] & blanks
RETURN
resAnd use this column for the x-axis of your visual:
mina97Helper III
Helper IIIhi please i need extra help i reallt appreciate it
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 have the following data
| Fisrt 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 |