Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

TheoC Thanks for answering. It works but gives wrong values.

Other info- I have two tables related to each other on ID.

Table 1 has columns-Start time, End Time, ID

Table 2 has columns- ID, Volume

 

Speed = divide volume by Time difference btw start and end time. And then need to further divide by max speed.

 

Only measure is giving the correct value and not the calculated column.

I have put the slicer of Start Time on the report based on which it will calculate max speed.

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Anonymous What measure are you using? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      TheoC  

      Measure 2 = sum('table2'[volume])/Sum('table1'[Time])
       
      Calculated column --> Time = (DATEDIFF('table1'[start time], 'table1'[end_time],SECOND))
      • TheoC's avatar
        TheoC
        Community Champion
        4 years ago

        Anonymous can you provide me with the outputs that you are seeing or provide example data please. Unfortunately, it's very challenging try to understand why a basic measure works as required in this instance but there are complications with the column.