Forum Discussion
Solved
Yesterday formula using datetime datatype in DAX
Hi All,
I need to compute yesterday with all the DateTime values but when I use the below-calculated column it returns just one value. I need all the date time values from yesterday.
Yesterday = IF('DATE'[Date] = (DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW()-1))), 1 , 0)Please help.
hi, Kolumam
For the data type is datetime, so try this formula:
New Yesterday = IF(DATE(YEAR('DATE'[Date]), MONTH('Date'[Date]), DAY('Date'[Date]))= (DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW()-1))), 1 , 0)Result:
Best Regards,
Lin
3 Replies
What are you going to do with this column after you create it? It is unlikely that this is the best approach. What do you actually want to achieve?
Hi Kolumam ,
This is a way to do what you want, but as MattAllington said it might not be the best approach to your problem :
Yesterday = IF(DATEADD('DATE'[Date],1,DAY)=TODAY(),1,0)Regards,
Etienne
hi, Kolumam
For the data type is datetime, so try this formula:
New Yesterday = IF(DATE(YEAR('DATE'[Date]), MONTH('Date'[Date]), DAY('Date'[Date]))= (DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW()-1))), 1 , 0)Result:
Best Regards,
Lin
