Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Continued Contributor
4 years ago
Solved

Time in Power Query

Hi everyone, could someone help me out convert this DAX measure into M code please.    Basically, it is just getting the date and time from 6am til 3am the next day. thanks in advance 🙂 Adjuste...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    ronaldbalza2023 , Try like

     

    if Sales[Time] <= #time( 3, 0, 0 ) then Date.Adddays(Sales[Date],-1)
    else if Sales[Time] < #time( 6, 0, 0 ) then Date.Adddays(Sales[Date],-1)
    else if Sales[Time] >= #time( 6, 0, 0 ) Sales[Date]

amitchandak's avatar
amitchandak
Super User
4 years ago

ronaldbalza2023 , Try like

 

if Sales[Time] <= #time( 3, 0, 0 ) then Date.Adddays(Sales[Date],-1)
else if Sales[Time] < #time( 6, 0, 0 ) then Date.Adddays(Sales[Date],-1)
else if Sales[Time] >= #time( 6, 0, 0 ) Sales[Date]