Compare data by columns

Varshi288 — Thu, 30 Apr 2020 07:05:36 GMT

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"))

Re: Compare data by columns

Anonymous — Thu, 30 Apr 2020 23:00:12 GMT

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

topic Compare data by columns in DAX Commands and Tips

Compare data by columns

Re: Compare data by columns