Forum Discussion
Jen_41
4 years agoRegular Visitor
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...
- 4 years ago
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
4 years agoRegular Visitor
Hi
Thnak you for your response. I've tried the formula suggested but am getting the below error message?
Anonymous
4 years agoNot applicable
HI Jen_41,
They are DAX formulas and you can't use them in power query columns, please back to the data view and create a calculated column with these formulas.
Regards,
Xiaoxin Sheng