Forum Discussion
Solved
Dax text comparaison
Hi all I need your help ! I have a table like below, I need to comparaire value from category A with values from category A.1 and A.2 I need a new column with flag "same" or "different". How...
Load your data into the power bi desktop
Now create the flowing calculated column
Status =
VAR val = data[Value]
VAR result =
CALCULATE ( COUNTROWS ( data ), ALL ( data ), data[Value] = val )
RETURN
IF ( result == 1, "different", "Same" )You will get your expected results.
Load your data into the power bi desktop
Now create the flowing calculated column
Status =
VAR val = data[Value]
VAR result =
CALCULATE ( COUNTROWS ( data ), ALL ( data ), data[Value] = val )
RETURN
IF ( result == 1, "different", "Same" )
You will get your expected results.
Royel ,Thank you but I need to add a condition on Category because I can have a completly different categories like B etc. How can I do that ? Thank you !
Why do we not use EARLIER function ?
