topic Previous date if it's before 6:00 in DAX Commands and Tips

Previous date if it's before 6:00

Anonymous — Thu, 30 Dec 2021 07:20:39 GMT

How to replicate the below formula in DAX?

if the time is before 6 am in the "Section End DateTime" column then it should be of previous dates in the next column called "Prod. Date" because the previous day's night shift ends at 5:59am
in Excel I used "=IF(V2<"6:00",W2-1,W2)" formula.

Re: Previous date if it's before 6:00

wdx223_Daniel — Thu, 30 Dec 2021 07:43:29 GMT

Prod. Date=INT([Section End DateTime]-6/24)

Re: Previous date if it's before 6:00

Anonymous — Thu, 30 Dec 2021 08:19:10 GMT

Thanks, A much wdx223_Daniel 😍