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

 

The reason it is blank is because there are no matching rows through the relationship.

 

Are all your values in your Execution Time field the same day?  or do they vary?

Dragos's avatar
Dragos
Frequent Visitor
8 years ago

Hi Phil

 

The dates are different .

Every day new sales .

 

What i did i created a new column only with the time and did the relationship between mytable[time] and timetable[minute group].

And then to filter by day .

 

I thought this way will match.

 

Thank you and Regards,

Dragos 

 

  • 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 :)