Forum Discussion
Solved
DAX IF statement
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
cottrera ,
Id Datatype of date is date
then try a new column
IF([DAte] =date(2020,10,7), "Yes", "No")
2 Replies
cottrera ,
Id Datatype of date is date
then try a new column
IF([DAte] =date(2020,10,7), "Yes", "No")
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
