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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
SachinFG
Frequent Visitor

Match datetime column with another datetime column

I have a datetime column ( dd/mm/yyyy HH:MM:SS TT). I want to match this with another datetime column with same structure. How can i do this in dax ? 

1 REPLY 1
amitchandak
Super User
Super User

@SachinFG , You can use  =

if([date1] =[date2],1,0)

 

or if( datediff([Date1], [Date2], second) =0,1,)

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.