cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alexstain New Member
New Member

Add column creation date

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

1 REPLY 1
Super User
Super User

Re: Add column creation date

Hi @alexstain 

Can you demonstrate current data format and desired outpun?

Many Thanks
Mariusz

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 113 members 1,771 guests
Please welcome our newest community members: