Forum Discussion

po's avatar
po
Icon for Post Prodigy rankPost Prodigy
4 years ago

Dataflows - format object as time with format HH:MM

Hi,   New to dataflows and have changed column to be of type Time which means when use dataflow in a dataset shows as HH:MM:SS   How can we set the time format on a column in power query (dataflo...
Need Help
jennratten's avatar
jennratten
Icon for Super User rankSuper User
4 years ago

Hello - you can change the appearance of the time in the dataflow by tranforming like this (:

= Table.AddColumn(#"Previous Step", "HHmm", each DateTime.ToText([#"Date - Copy"], "HH:mm"), type time)

 

'Grouping columns into subfolders' - I think you are referring to creating hierarchies.  This cannot be done in Power Query. The closest thing would be to have a dimension table that includes the hierarchies and then relate that table to the fact table.  You would still have to create the hierarchies in the data model though.

 

po's avatar
po
Icon for Post Prodigy rankPost Prodigy
4 years ago

Hi,

 

Thanks for reply.

 

Do you need to create a separate time column?

 

e.g. if just wanted to have date_created itself formatted as HH:MM is this possible?

 

Not meaning hierarchies as such, just the display folder part which get when create dat amodel in power bi desktop.

 

Rtaher than have to do that each time user uses that dataflow, woudl rather have just liked to set in the dataflow itself.  screenshot below of what do in ower bi desktop for this.