cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper V

## Simple IF Dax Expression

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

1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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.

Super User

@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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors