Join Tables for a IF Statement

[Anonymous]

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.

[harshnathani]

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)

[Anonymous]

I would like to a evaluation. If Join True

[harshnathani]

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

[Anonymous]

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. 

[harshnathani]

@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,

[Anonymous]

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

[harshnathani]

@Anonymous ,

Are your tables related.

You can try using RELATED function.

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

Regards,

HN

[Anonymous]

Yes the 2 tables are related

[Anonymous]

I solved my problem with Related.

Thanks

[harshnathani]

Hi @Anonymous ,

Great that you solved the problem using RELATED.

Kudos will be highly appreciated.

Regards,

Harsh Nathani

[harshnathani]

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

[Anonymous]

Column