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" Repa...
cottrera ,
Id Datatype of date is date
then try a new column
IF([DAte] =date(2020,10,7), "Yes", "No")
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