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 Dragos

 

Good idea creating a new column with just the time.  Do they match now?  

Dragos's avatar
Dragos
Frequent Visitor
8 years ago

Hi Phil

 

Unfortunatly no .

Seems that it brings me only the total.

 

Best,

Dragos

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    The values in columns on both sides of a relationship need to be the same.

     

    Any chance you can share your PBIX file?  Delete all tables apart from these two.  Delete every column from your main table apart from the bare minimum and share.  I let you know what to do then :)

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        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.