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

     

     

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

SkorpionAAM - Hard to follow, but looks like you are trying to compare one row with some other rows. In general, see my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586.
The basic pattern is:
Column = 
  VAR __Current = [Value]
  VAR __Previous = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Value])
RETURN
  __Current - __Previous

 

In your case, maybe:

Column =
  VAR __Table = FILTER('Table',[Survey]=EARLIER([Survey]) && [Round] <> EARLIER([Round]))
RETURN
  IF(NOT(ISBLANK(COUNTROWS(__Table))),"Match","Not Match")

 

Otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

  • 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