Forum Discussion

SkorpionAAM's avatar
SkorpionAAM
Icon for Helper V rankHelper V
6 years ago
Solved

Match Values in Same Columns with condiiton

I have data whch contain Survey Round id and Place digital Address   Survey round havdtwo IDs 1 and 2   now what i looking here is if round 1 have same place digital address in round 2 then its g...
data protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI SkorpionAAM 

    Try the below DAX to create a new column

     

     

    _LOOK = 
var _val = LOOKUPVALUE('Table'[survey_round_id], 'Table'[place_digital_adress], 'Table'[place_digital_adress],BLANK())
RETURN IF(ISBLANK(_val),"Match","Not Match")

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI SkorpionAAM 

Try the below DAX to create a new column

 

 

_LOOK = 
var _val = LOOKUPVALUE('Table'[survey_round_id], 'Table'[place_digital_adress], 'Table'[place_digital_adress],BLANK())
RETURN IF(ISBLANK(_val),"Match","Not Match")