hour in power BI language M

[sakamotothais]

Hi,

I need help, if anyone knows.

I have a datetime column in the table, I make the direct query connection. And I want to add a column by bringing only the time, hour.
However when I put language m formula like datetime.time or time.hour, the query is not supported.

Then I need to add -3 hours in the hour column that I'll add.

Can anyone guide me where I'm going wrong?

Code:

let
    Source = Sql.Database("10.0.6.70,1433", "DailyBookings34"),
    DMBookings_BookingByLeg = Source{[Schema="DMBookings",Item="BookingByLeg"]}[Data],
    #"Filtered Rows" = Table.SelectRows(DMBookings_BookingByLeg, each Date.From([BookingDate]) = Date.From (DateTime.LocalNow ()) or Date.From([BookingDate]) = Date.AddDays (Date.From (DateTime.LocalNow ()) , -1) or Date.From([BookingDate]) = Date.AddDays (Date.From (DateTime.LocalNow ()), -7)),
    #"Added Custom2" = Table.AddColumn(#"Added Conditional Column", "BKDate", each DateTime.From([BookingDate])),
    #"Changed Type" = Table.TransformColumnTypes(#"Added Custom2",{{"BKDate", type datetimezone}}),
    #"Added Custom3" = Table.AddColumn(#"Changed Type", "Personalizado", each DateTime.Time([BKDate])),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom3",{{"Personalizado", type time}})
in
    #"Changed Type1"

thanks

[Interkoubess]

Hi @sakamotothais,

Did you try Time.Hour([BKDate])?

Let us know.

Ninter.

[sakamotothais]

Hi,

 I try but the query is not supported.

 

Note: My field is datetime when I make the formula it gets integer.

Thanks

[MarcelBeug · Accepted solution]

Because you are using Direct Query mode, you have limited query capabilities; time intelligence functions are not supported.

See the article of September 25, 2017, Use DirectQuery in Power BI Desktop

[sakamotothais]

Yeah, is true. 

I'll try to mount the dashboard with what's possible in the query editor M

Thanks