Forum Discussion
DAX or Query: Compare two columns in different Tables
‎Hi PowerBI I have 2 tables and want to compare two columns (one from each) in query editor or dax. I just need a yes they (the text values) match or no (text values) don't match in a new ...
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())
Thank you !! aj1973 this has worked!! 🙂
Good
one last thing to know where the Blank is coming from
those numbers don't existe in the other table
aj1973 Hi Amine,I have a new table which is the different date range of orders (table 1) How do I move all the calculations to connect to the new table instead of the exisiting table 1?
I don't want to redo all the calculations.
Thanks
Anonymous sorry but i am kinda lost here. what's the issue? I thought it was solved Ain't it?