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:
mina97IT WORKS perfectly THANK YOU SO MUCH!!!! you are a lifesaver
- mina97
hi 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 email 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