Add column creation date

[Anonymous]

Hi,

I use Power BI to make reports from a databse with ODBC link.

In my database, each field has a creation date, but power BI doesn't show it as a column.

I need to display a column showing the creation time of each record, to be able to create another one with hour ranges, to analyze my records on hour ranges (morning, noon, afternoon, evening).

My IT manager says to use a querry : extract(hour from (audit).createtime) but I don't see how to use it with power bi.

Can anybody help ?

Thanks

[Mariusz]

Hi @Anonymous 

Can you demonstrate current data format and desired outpun?

Many Thanks
Mariusz