Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
v_mark
Helper V
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
v-jingzhang
Community Support
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.

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
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.

amitchandak
Super User
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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.