matching dates - except when there are no values

acg — Tue, 31 Jan 2023 23:57:59 GMT

I want to compare date 1 with date 2 and create a new columne indicating whether the two dates are matching or not.

As such the DAX function below works. But how can I write 'not specified' in the column 'matching', if neither date 1 nor date 2 have a date?

I tried that with not (isblank .. - but this appeard not to work. Istead the output shows yes - for both cells being empty.

Any ideas?

matching =

if(NOT(ISBLANK(Table[Date_1])) = (NOT(ISBLANK(Table[Date_2]))),"Yes","No")

in this last line we should see 'not specified' instead of 'yes'

Re: matching dates - except when there are no values

wdx223_Daniel — Wed, 01 Feb 2023 00:21:32 GMT

=IF(ISBLANK(Table[Date_1])&&ISBLANK(Table[Date_2]) ,"not specified",IF(Table[Date_1]=Table[Date_2],"yes","no"))