Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 ? 
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You can use  =

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

 

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