Forum Discussion

MarcUrdang's avatar
MarcUrdang
Icon for Post Patron rankPost Patron
7 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"
Need Help
kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
7 years ago

I found 2 things.

One is you have a many to many relationship between the tables. That might be confusing things. I deleted the existing relationship and was able to recreate it as one to many

The other thing I notice is that when i try to include the names sailing day field in a measure it was not available in the intelisense list

so it looks like there is something funny with that column, since it should be available

because i don't have the underlying data i can't see the data type in the query editor but look at this posting which suggests that an inappropriate data type can block the column from being used. https://community.powerbi.com/t5/Desktop/Relationship-with-date-table-not-working/td-p/149052

    • kentyler's avatar
      kentyler
      Icon for Solution Sage rankSolution Sage
      7 years ago

      I think I've gone as far as I can. The issue on the interface level is that the calculated column does not show up as available for either other calculated columns or measures. I tried calculating a numeric day of the week instead of a string and that didn't help. I don't think I can go farther over email. If you want to invest the time to do a screen share we could have a conversation, but I can't promise any results. At this point I would fall back and try loading a simpler table that had only some identifying fields and the day of the week. Create a relationship to it and see if the day of the week field shows up in the intellisense. If it does, then gradually expand the "simple" version out to be the full table you want to load, checking as you go to see where it "dissappears". Thanks for the responses, it's been interesting.

      • MarcUrdang's avatar
        MarcUrdang
        Icon for Post Patron rankPost Patron
        7 years ago

        Hi Ken

         

        thanks so much for your help thus far. I'm new to Power BI so I'm not really sure how all this works .. ie you getting remunerated for your time. However I am quite desparate and would appreciate a Skype call or the like that we can. 

         

        thanks so much

        Marc