DAX IF statement

[cottrera]

Hi

I am using direct query and have  Repairs table with references and dates. I would like to add a new column with an IF statement that says IF Table = 07/10/2020 (UK date) , "Yes", No"

Repairs Table
Job Ref	Date	New Column
1	01/10/2020	No
2	02/10/2020	No
3	12/10/2020	Yes
4	10/10/2020	Yes
5	10/10/2020	Yes
6	01/10/2020	No
7	02/10/2020	No
8	07/10/2020	Yes
9	08/10/2020	Yes
10	05/10/2020	No
11	06/10/2020	No
12	12/10/2020	Yes
13	13/10/2020	Yes
14	04/10/2020	No
15	15/10/2020	Yes

thanks

Richard

[amitchandak · Accepted solution]

@cottrera ,

Id Datatype of date is date

then try a new column

IF([DAte] =date(2020,10,7), "Yes", "No")

[cottrera]

Hi 

thank you for your response

 I tried IF([Date] =date(2020,10,7), "Yes", "No") and received a sytax error

How ever when I just added IF([Date] =date(2020,10,7) it gave me a true or false which is acceptable.

I will log this as resolved as between us it was.

thank you RIchard