DAX Formula Issue-Does not Support comparing value of Date type with Text type

[Anonymous]

Hey guys, 

I am trying to create the DAX fromula below:

If(Begin-Date)>"7/01/2019", "Yes", "No")

But it gives me the following error: Does not support comparing the value type of Date with value type of Text. 

How can I avoide that issue?

Thanks, 

Sona

[FarhanAhmed · Accepted solution]

If( (Begin-Date) >Date(2019,07,01), "Yes", "No")

[amitchandak · Accepted solution]

@Anonymous , as a new column

If([Begin-Date]> date(2019,01,7), "Yes", "No")

New measure

If(max(Table[Begin-Date])> date(2019,01,7), "Yes", "No")

In the case of the measure take care of row context. refer : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You cannot compare the different value types. You could use FORMAT(Begin-Date,"mm/dd/yyyy") to get text values or use DATE(2019,07,01) to get date values.

[amitchandak · Accepted solution]

@Anonymous , as a new column

If([Begin-Date]> date(2019,01,7), "Yes", "No")

New measure

If(max(Table[Begin-Date])> date(2019,01,7), "Yes", "No")

In the case of the measure take care of row context. refer : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451

[FarhanAhmed · Accepted solution]

If( (Begin-Date) >Date(2019,07,01), "Yes", "No")