Simple IF Dax Expression

[v_mark]

Been trying to figure out how I can calculate this type of condition in dax. Looking into a calculated column. 

"If in resolved status and resolved datetime not = to 1/1/1900 is datetime < call datetime"

To provide more context 

All of them are column inside of a one table

Status is mainly a status per ticket = Open, Closed, Resolved 

Resolved DateTime = Are timestamps  / Date/time 

Call Datetime = Timestamps / Date/time 

[v-jingzhang · Accepted solution]

Hi @v_mark 

Sorry I'm confused about the description "is datetime < call datetime", what does this mean? And what should be the result when the if condition is true and when it's false?

You can use "&&" and "||" to combine multiple conditions in an IF function. And when you use signs like =, <>, <, >... the values on both sides of the sign should be in the same data type so that they can be compared with each other.

Column = IF('Table'[Status]="Resolved" && 'Table'[Resolved DateTime].[Date]<>DATE(1900,1,1) && 'Table'[Resolved DateTime]<'Table'[Call DateTime],"True_Result","False_Result") 

Hope this helps.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak]

@v_mark , You can create a new column like

if([status] ="Resolved" && [Resolved DateTime] <> Date(1900,01,01) && [Resolved DateTime] < [Call Datetime],1,0)

you might have to change some condition