Forum Discussion
Id based on multiple columns
Hello, I need an id based on three different columns with text. Right now the way that I am doing this is by concatenating all three columns together using the DAX below and it is working fine. ...
bclrk ,
Maybe something like below?
factorid =
VAR _1 = factors[deskcode]
VAR _2 = factors[model_name]
VAR _3 = factors[factor]
RETURN
CONCATENATE ( _1, CONCATENATE ( _2, _3 ) )
Regards,
Jimmy Tao
I don't think that would work because there are different values in a single column that need to be distinguished.