Forum Discussion

bclrk's avatar
bclrk
Icon for Advocate II rankAdvocate II
6 years ago

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. ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

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

bclrk's avatar
bclrk
Icon for Advocate II rankAdvocate II
6 years ago

I don't think that would work because there are different values in a single column that need to be distinguished.