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
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.