Forum Discussion

Varshi288's avatar
Varshi288
Icon for Resolver II rankResolver II
6 years ago

Compare data by columns

Hi All , I have merged two tables Salesboost where I am comparing GUID from both the tables.that is achieved from below DAX query. Now I need to compare GUID along with country from two tables from...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Varshi288 ,

 

Not very clear to understand unless you share sample Data.

 

Follow the below article on the error.

 

https://www.sqlgene.com/2019/04/30/dax-error-the-expression-refers-to-multiple-columns-multiple-columns-cannot-be-converted-to-a-scalar-value/

 

Also, try using the SEARCH OR FIND Function.

 

https://dax.guide/find/

https://dax.guide/search/

 

Regards,

Harsh Nathani

 

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!