Dax if "dateA" is later than "DateB", then return "Value"

[Anonymous]

I've tried below 2 Dax, purpose is to return the value "FU Appeal" if Date A is later than Date B.  but below 2 both not working. 

IsFUAppeal = if(and('DA - One Off 2016'[Response Campaign]="2016 Syria Winterisation Appeal",'DA - One Off 2016'[Donation Received Date]>='DA - One Off 2016'[FU 2016 Syria Winterisation Appeal]),"FU Appeal","1st Appeal")

IsFUAppeal = if(and('DA - One Off 2016'[Response Campaign]="2016 Syria Winterisation Appeal",'DA - One Off 2016'[Donation Received Date]>=05/12/2016),"FU Appeal","1st Appeal")

[v-yuezhe-msft]

Hi @Anonymous,

I test your first formula and it works as expected, please check the following screenshot.

Regarding to your second formula, please change it to the following formula and check if you get desired result, there is also an example for your reference.

IsFUAppeal1 = if(and('DA - One Off 2016'[Response Campaign]="2016 Syria Winterisation Appeal",'DA - One Off 2016'[Donation Received Date]>= Date(2016,5,12)),"FU Appeal","1st Appeal")

For more details about the above example, you can review this attached PBIX file.

If you still have problems when comparing dates, please help to share sample data of your table and post expected result here , also we need to know which data type you store the date values as.

Thanks,
Lydia Zhang