Compare data by columns

[Varshi288]

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 the second query but getting error like "Multiple columns cannot be converted to a scalar value." any help?

Q1:

SalesBoost1&2 = IF(SalesBoost[Account: GUID]=SalesBoost[SalesBoost2.Customer GUID],"1&2",
IF(ISBLANK(SalesBoost[Account: GUID]),"2",
IF(ISBLANK(SalesBoost[SalesBoost2.Customer GUID]),"1")))

Q2:

CC_GUID_1 = 
var SB = CONCATENATE(SalesBoost[Account: GUID],SalesBoost[Country])
VAR SB1 = CONCATENATE(SalesBoost[SalesBoost2.Customer GUID],SalesBoost[SalesBoost2.Country])
return
IF(SB=SB1,"1&2",
IF(ISBLANK(SB),"2","1"))

[harshnathani]

@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-colu...

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!!