Forum Discussion
Solved
Row Comparison and Detecting Different Corresponding Values
Hi Experts, Kindly help to give idea on how should I compare below row to detect which ID have more than 1 names. My Original Dataset only consists of Column ID and Name. And I want the result t...
Hi,
Please check the below picture and the attached pbix file.
Expected result CC = VAR _condition = COUNTROWS ( SUMMARIZE ( FILTER ( Data, Data[ID] = EARLIER ( Data[ID] ) ), Data[Name] ) ) = 1 RETURN IF ( _condition, "ID per 1 name", "ID have more than 1 names" )
Hi,
Please check the below picture and the attached pbix file.
Expected result CC =
VAR _condition =
COUNTROWS (
SUMMARIZE ( FILTER ( Data, Data[ID] = EARLIER ( Data[ID] ) ), Data[Name] )
) = 1
RETURN
IF ( _condition, "ID per 1 name", "ID have more than 1 names" )
Hi Jihwan_Kim ,
Thank you for your solution. It is working. Really appreciation your support and time