Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Add Yes/No column in Power Query

Hello   I have the solution in Dax using Related, but I can't get a one to many relationship on the tables I'm using. So I wanted to check if there is a solution in Power Query "Add conditional col...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

You should be able to do it. Check I got two columns like that. Just need to ensure one value you have to use some function

 

 

Max Sales order id = Maxx(filter(sales,Sales[item_id]='Item'[Item ID]),Sales[Order Id]) 
Max customer = MAXX(filter(Sales,Sales[Order Id]='Item'[Max Sales order id] && Sales[item_id]='Item'[Item ID]),Sales[Customer ID])

 

 

These are columns, not measures.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak  Thanks for replying

     

    I struggling to understand your answer.

     

    I have two tables with no relationship and I want to add a yes/no column to Table1 based on matching some criteria in table2.

     

    I have a DAX query below that works if I have a 1 to Many relationship. If the tables have a relationship on the IDs, it wll be Many to Many as I have multiple entries. 

     

    Correct = IF(([Name] = RELATED(TableB[Name])) && ([REAL_TIME] >= RELATED(TableB[REAL_TIME - 3] )) && (TableA[REAL_TIME] <= RELATED(TableB[REAL_TIME + 3])), "YES" , "NO")

     

    Thanks

    Joe

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.