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
Anonymous
Not applicable

IF DateTime on Column is greater than 2 February 2022 at 5:00:00 pm

Hi all

 

i have question ,
IF DateTime on Column is greater than 2 February 2022 at 5:00:00 pm will result late , else ontime 

 

Thanks 
SE

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

@Anonymous Write the following DAX:

Column = IF(Table[DateTime Column]>"02-02-2022 05:00:00" , "Late","OnTime")

Edit: Column = IF(Table[DateTime Column]>dt"2022-02-02 05:00:00" , "Late","OnTime")

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

2 REPLIES 2
Tahreem24
Super User
Super User

@Anonymous Write the following DAX:

Column = IF(Table[DateTime Column]>"02-02-2022 05:00:00" , "Late","OnTime")

Edit: Column = IF(Table[DateTime Column]>dt"2022-02-02 05:00:00" , "Late","OnTime")

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
PijushRoy
Super User
Super User

In DAX or Power Query

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.