topic IF statement between 2 fields from different Data sources in DAX Commands and Tips

IF statement between 2 fields from different Data sources

Anonymous — Fri, 22 Jan 2021 12:21:32 GMT

Hi,

I need to create another column/calculated field - If(id_vendor="UNKN",Rerefence,id_vendor).

i guess because id_vendor and reference are fields from different data sources, i cant. Do you have any idea how to do this?

You can see bellow, how the table looks like.

Thanks in advance

aj1973 — Fri, 22 Jan 2021 14:23:26 GMT

Hi Anonymous

Normally you are looking for a fourmula like this :

Column =

var col = CONTAINS(Table1, Table1[id_vendor], "UNKN")

Return

IF(col ,RELATED(Table2[Reference]), id_vendor)

However for this formula to work Columns 'Reference' and 'id_vendor' have to be same format(Text)

Anonymous — Sat, 23 Jan 2021 17:49:22 GMT

Unfortunately, it does not work. i got an error when using this REATED function. can you help please ?