Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @Anonymous
Can you demonstrate current data format and desired outpun?
Many Thanks
Mariusz
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |