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")

     

     

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

SkorpionAAM , I looked at the data. I do see a common value between round 1 and 2 where I can compare the values and say that place_digit_address is same

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

    Yes