topic Re: Join Tables for a IF Statement in DAX Commands and Tips

Join Tables for a IF Statement

Anonymous — Tue, 26 May 2020 21:24:36 GMT

What is wrong DAX?

OverrideTermFlag = IF(FILTER(CROSSJOIN('Fact_Policy','Override New Term'),'Fact_Policy'[ChannelDate]='Override New Term'[ChannelDate]),"Y","N")

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Re: Join Tables for a IF Statement

Anonymous — Tue, 26 May 2020 21:54:47 GMT

Hi Anonymous ,

Are your creating a new table, measure or column.

incase you are creating a table.

OverrideTermFlag = FILTER(CROSSJOIN('Fact_Policy','Override New Term'),'Fact_Policy'[ChannelDate]='Override New Term'[ChannelDate]))

this will join values where Fact Policy Date = Override Channel Date.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Re: Join Tables for a IF Statement

Anonymous — Tue, 26 May 2020 22:16:57 GMT

Column

Re: Join Tables for a IF Statement

Anonymous — Tue, 26 May 2020 22:17:59 GMT

I would like to a evaluation. If Join True

Re: Join Tables for a IF Statement

Anonymous — Wed, 27 May 2020 09:46:54 GMT

Anonymous ,

OverrideTermFlag = IF(FILTER(CROSSJOIN('Fact_Policy','Override New Term'),'Fact_Policy'[ChannelDate]='Override New Term'[ChannelDate]), = ???? , "Y","N")

Marked in Blue is your Filter Function.

Marked in Red is What you need to add as your evaluation parameter.

Hope this makes sense now.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Re: Join Tables for a IF Statement

Anonymous — Wed, 27 May 2020 12:09:27 GMT

Thanks

For you help

I am getting this error message. In addition it did not let me do the condition you provide so I did not include it.

OverrideNewTermFlag = IF(FILTER(CROSSJOIN('Fact_Policy','NewTermOverrideMatch'),'Fact_Policy'[DateChannel]='NewTermOverrideMatch'[DateChannel]),"Y","N")

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Re: Join Tables for a IF Statement

Anonymous — Wed, 27 May 2020 12:13:34 GMT

I just need to a create calculated field the flags on the 'FactPolicy' table that a record matched to the 'OverrideNew TermMatch' table.

Re: Join Tables for a IF Statement

Anonymous — Wed, 27 May 2020 12:15:14 GMT

Anonymous ,

This is because

CROSSJOIN('Fact_Policy','NewTermOverrideMatch'),'Fact_Policy'[DateChannel]='NewTermOverrideMatch'[DateChannel]

returns a Table.

Can you clearly state what is your requirement to help you better.

Please share sample data in text format.

Thanks,

Regards,

Re: Join Tables for a IF Statement

Anonymous — Wed, 27 May 2020 12:17:21 GMT

Anonymous ,

Are your tables related.

You can try using RELATED function.

Difficult to help without seeing your Data Model and some sample data.

Regards,

Re: Join Tables for a IF Statement

Anonymous — Wed, 27 May 2020 12:23:03 GMT

Yes the 2 tables are related

Re: Join Tables for a IF Statement

Anonymous — Wed, 27 May 2020 12:45:15 GMT

Anonymous ,

I have 2 tables which are related.

Regards,

Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Re: Join Tables for a IF Statement

Anonymous — Wed, 27 May 2020 13:55:01 GMT

I solved my problem with Related.

Thanks

Re: Join Tables for a IF Statement

Anonymous — Wed, 27 May 2020 14:28:11 GMT

Hi Anonymous ,

Great that you solved the problem using RELATED.

Kudos will be highly appreciated.

Regards,

Harsh Nathani