Forum Discussion

MattAdams's avatar
MattAdams
Icon for Helper I rankHelper I
8 years ago
Solved

DAX query to compare two columns from different tables

I have a join on Column A and Column B, from respectively Table A and Table B. Both contain date values. From DAX via table A, I'd like to say if the date of Column B is to Column A or fell between t...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    OK, I read that 3 times and I'm not following it. Can you explain it a different way? Sorry!

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

Here's an example:

 

Column = IF(RELATED('OtherTable'[ColumnB])=[ColumnA],1,0)

You could also possibly use LOOKUPVALUE.

Zuza's avatar
Zuza
Frequent Visitor
1 year ago

you just saved me a ton of work, ghatgpt suck's!!!!