Time in Power Query

[ronaldbalza2023]

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 🙂

Adjusted Date =
SWITCH (
TRUE (),
Sales[Time] <= TIME ( 3, 0, 0 ), Sales[Date] - 1,
Sales[Time] < TIME ( 6, 0, 0 ), Sales[Date] - 1,
Sales[Time] >= TIME ( 6, 0, 0 ), Sales[Date]
)

[CNENFRNL]

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))

[amitchandak · Accepted solution]

@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]