cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Phil_Seamark Super Contributor
Super Contributor

Re: Time calculation

HI @Dragos

 

Had a look at this tonight (finally).  The issue was with the [Time] column in your Sheet1 table.  It still contained milliseconds, so I added a new column [Time2] to Sheet1 that only has hours/mins/seconds.

 

I also converted the TimeKey column in the new table to be time rather than text.

 

I have attached the PBIX file to this message.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

KeithChu Regular Visitor
Regular Visitor

Re: Time calculation

Can you use binning to group the hour? In your case, create new group with 1 hour as the size of bin for the datetime field. 

Phil_Seamark Super Contributor
Super Contributor

Re: Time calculation

Hi @KeithChu

 

You can, just add a column to the time table that strips the minutes and seconds. 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Dragos Frequent Visitor
Frequent Visitor

Re: Time calculation

Hi Phil

 

This really solved my problem .

I can't thank you enough.

I already change it also in my .pbix and i fully understood the problem also.

 

Thank you and Regards,

Dragos