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")
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!