Forum Discussion
Comparing a field from one table with a field from another table. ie IF(X=Y,"true","false")
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.
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
- kentyler7 years ago
Solution Sage
OK, how about 1:00 Pacific Standard Time
We can try skype. on skype I'm [email protected].
To add you to my contacts I'll need your email address.
- MarcUrdang7 years ago
Post Patron
I'm unfortunately way asleep at that time :) .. that is 10pm my time ... I get up at 4am each morning for crossfit training so already asleep by then.
I don't want to inconvenience .. I will keep at it from my side. Such a pity not as easy as Tableau but still have to get this right.
thanks for your help thus far.