Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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 ,
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |