Forum Discussion
Solved
Comparing two queries
Hi I'm pretty new to this. I've searched through the forum and tried a few of the previously suggested solutions. Whenever I edit the solution to include my table and columns names I either end up w...
Jen_41 , You can try mergein power query.
You can create a column in DAX
column in table 1=
var _cnt = maxx(filter(Table2, Table2[Reference] = table1[Reference]), Table2[Reference] )
return if(not(isblank(_cnt)) , true(), false())
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Jen_41 , You can try mergein power query.
You can create a column in DAX
column in table 1=
var _cnt = maxx(filter(Table2, Table2[Reference] = table1[Reference]), Table2[Reference] )
return if(not(isblank(_cnt)) , true(), false())
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query