Forum Discussion
DAX or Query: Compare two columns in different Tables
Hi Anonymous
here you go
Attached the file
https://drive.google.com/file/d/1hMWpl1vwwXlj8yDKT8vmXLUF7S207jUU/view?usp=sharing
Hey add this to the measure if you don<t want to count the Blank rows
Count of MisMatch = CALCULATE(COUNTROWS(OEC_Service_Requests) , OEC_Service_Requests[Match/No Match__] = "No Match", OEC_Service_Requests[Status_Code ESR] <> BLANK())
Hi Rookzie
I don't understand what are you talking about !!!
Can you open a new thread with more details of your issue and share it with me please?
Hi aj1973 I had the same issue as Rookzie, looks like the formula worked with no errors but the but all the results are a "match" ,
Looking at this again I see that my tables don't have a common column, the common column, when they interact the common column or the intersection is in another table. Do you know how I can do this?
could you advise why this might be? thank you!
Hi Anonymous
Thank you for contacting me but this thread is more that a year old, there is always new things in Power Bi that I can help you with in your case. Besides every model is unqiue therefore can you share yours so I can be more helpfull?
As I replied to Rookzie, he needed to open a new thread however from what you have described maybe adding an external Excel file with a "Commun Column" could help you out!
So please Open a new thread and share your Model OR text me in Private if it would suits you better.
I have opened a new thread, thank you so much!