Forum Discussion

YcnanPowerBI's avatar
YcnanPowerBI
Icon for Helper II rankHelper II
2 years ago
Solved

Multiplying measure against fixed time

Hello community,   I have a measure that counts number of tickets processed**1 Tickets Created = CALCULATE(COUNT(Append1[Ticket Created]))** I need to mutiply that against a fxed time value, ie. 0...
Need Help
  • SivaMani's avatar
    SivaMani
    2 years ago

    YcnanPowerBI , try this in a measure

    Total Time = FORMAT(TIME(0,[1 Tickets Created] * 5,0),"hh:nn:ss")
YcnanPowerBI's avatar
YcnanPowerBI
Icon for Helper II rankHelper II
2 years ago

Hi, Sorry for not being more clear.  Hope this helps. 

 

Here is a screenshot of expected results.  1 Tickets Created is an output of CALCULATE(COUNT(Append1[Ticket Created]))  In this example I multipied that against 5 minutes

 

 

1 Tickets CreatedTotal Time
40:20:00
20:10:00
60:30:00
80:40:00
10:05:00

 

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
2 years ago

YcnanPowerBI , try this in a measure

Total Time = FORMAT(TIME(0,[1 Tickets Created] * 5,0),"hh:nn:ss")
  • YcnanPowerBI's avatar
    YcnanPowerBI
    Icon for Helper II rankHelper II
    2 years ago

    Worked great! Thank you for your time!

    • SivaMani's avatar
      SivaMani
      Icon for Resident Rockstar rankResident Rockstar
      2 years ago

      Glad that it worked, cheers!