Forum Discussion

Icon for Post Patron rank

Post Patron

6 years ago

Comparing a field from one table with a field from another table. ie IF(X=Y,"true","false")

Please can you advise how to compare a filed in one table to a field in another table. ie If(x=y,"true","false"

Icon for Solution Sage rank

Solution Sage

6 years ago

The simplest way is to create a realtionship between the tables. Have you tried that ? Then you can write your forumla in a calculated column.

MarcUrdang
Post Patron
6 years ago
Hi .. thank you for your response.... sure I have .. I use fieds from there in a number of calcs.

I could attach the workbook for you to see?

thanks
Marc
- kentyler
  Solution Sage
  6 years ago
  I'd be glad to look at it.
  - MarcUrdang
    Post Patron
    6 years ago
    wow .. thanks .. I'm an old Tableau user converting to PBI so learning the ropes again.
    
    Just wondering where to attach the .pbix
- MarcUrdang
  Post Patron
  6 years ago
  actually not in calcs .. just in the views
  - kentyler
    Solution Sage
    6 years ago
    don't understand that...
    I'm going out for coffee. If you could share the file on one drive or google drive I'll take a look when I get back.