Yesterday formula using datetime datatype in DAX

[Kolumam]

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.

[v-lili6-msft · Accepted solution]

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

[Anonymous]

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

[MattAllington]

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?