DAX command with multiple conditions for new column

[nmbl]

Hi,

I am trying to create a column with the requirement. I want to filter out the rows where Date1<Date 2 only when Date1 has Data

If Date1 is blank  and if Date1>Date2 then "True" else "False".

Getting error "DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values".

I have tried the same logic with whole number instead of True and false still getting the same error.

[v-chenwuz-msft]

Hi @nmbl ,

Please check whether the type of date1 or date2 is the same. 

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@nmbl , Try

In power query

if Date1 = null and Date1>Date2 then 1 else 0

in DAX

if(isblank([Date1]) && Date1>Date2 , true(), false())

[nmbl]

Thank you for the response, I have applied 

Column 2 =

IF(

    'Lead'[Date1]="",

    "",

    IF(

        'Lead'[Date1] < 'Lead'[Date2],

        "0",

        "1"

    )

)

Getting Error "DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values".