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]

CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago

Simplify your measure,

Adj Date = Sales[Date] + ( SALES[Time] >= 6/24 ) - 1

 

It's equally simple in PQ,

= Table.AddColumn(#"Changed Type", "Adj Date PQ", each Date.AddDays([Date], Byte.From([Time]>=#time(6,0,0)) - 1))