test =
IF(Prospects[Contact Create Date]=Prospects[Campaign Member Create Date],“yes”,“no”)
and what I found out is that both date columns are date/time stamped so if a date in one column shows 4/29//2022 12:00 AM and the other column shows 4/29/12:28:28 AM, the results show “no”, I would like the measure to only look at the mm/dd/yyyyy for its analysis and not the time .
As per the recommended best practices, you should split the date/time column into two separate columns i.e., one for Date and another one for Time. By doing so, firstly, you’ll be able to overcome this type of problem. Secondly, when doing time intelligence calculations, you’ll be able to achieve the results correctly and finally but most importantly, it’ll also optimize the file size as well.
Hoping you find this helpful and solves your problem as well.
You can use format to convert datetime into date before evaluation
Like below
test =
VAR dt1=Format(Prospects[Contact Create Date],"mm/dd/yyyy")
VAR dt2=Format(Prospects[Campaign Member Create Date],"mm/dd/yyyy")
return
IF(dt1=dt2,"yes","no")
But i agree with @Harsh it will help you in reducing the data size of report also which eventually help in performance.
Insert “Space” as a delimiter and then it’ll split them in two different column like it’s shown in the above picture where one column contains date and another contains time.
