topic I need to subtract one day if the time is between 12AM and 2AM in DAX Commands and Tips

I need to subtract one day if the time is between 12AM and 2AM

tdisalvo — Tue, 30 Jun 2020 15:25:52 GMT

I have a Time field =IC_HistoryProducts[Time]

And a Date field= IC_HistoryProducts[TransactionDate]

What I need is to subtract 1 day from the date field if the time field is between 12AM~2AM

This is driving me nuts and could use some help

jthomson — Tue, 30 Jun 2020 15:53:54 GMT

What does this do:

newcolumn = if(hour(IC_HistoryProducts[Time])<2, previousday(IC_HistoryProducts[TransactionDate]),IC_HistoryProducts[TransactionDate])

Pulkit — Tue, 30 Jun 2020 16:01:08 GMT

Hi,

Try

new column = IF([Timecolumn]>12:00AM,IF([Timecolumn]<2:00AM,DATEADD([datecolumn],-1,date),[datecolumn])

I am not sure if this is it so let me know if it works.