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 ? 

1 Reply

  • 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,)