Forum Discussion

Dragos's avatar
Dragos
Frequent Visitor
8 years ago
Solved

Time calculation

Hi Expert I'm new to power bi and I search for a solution to sum between time: Column 1 I have name of seller. Column 2 I have time from 00:00:00 to 23:59:59 Column 3 I have prices . What I want ...
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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.

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi KeithChu

 

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

Dragos's avatar
Dragos
Frequent Visitor
8 years ago

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