topic Re: Match datetime column with another datetime column in DAX Commands and Tips

Match datetime column with another datetime column

Anonymous — Fri, 20 Nov 2020 03:01:30 GMT

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 — Fri, 20 Nov 2020 03:31:33 GMT

Anonymous , You can use =

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

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