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 =...
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
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