Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to minus the Date/Time format ?

Hi All,   I created in table Dim Date an calculated column called GetTime. This GetTime ( formula Gettime = NOW() )  gives a current time from my PowerBI Desktop.   The current time is now at 13:...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi Anonymous,

     

    You can try this formula in your scenario.

    ResultMeasure =
MIN ( 'Table1'[GetTimeCol] )
    + SIGN ( MIN ( 'Table1'[Time] ) ) * TIME ( 0, ABS ( MIN ( 'Table1'[Time] ) ), 0 )

    I would suggest that we create a calculated column instead, which would be simpler.

     

    ResultCol =
[GetTimeCol]
    + SIGN ( [Time] ) * TIME ( 0, ABS ( [Time] ), 0 )

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    vanessafvg

     

    Thanks for your response. Your formula works perfect when we have a delay of 4 minutes on some waiting room.

     

    But what if we have a early estimated time of -4 minutes?  How can i calculate this?

     

     

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      9 years ago

      i am not sure would that be held in your rootid?