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. 00:05:00 or 5 minutes.  Help please......

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

5 Replies

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

    YcnanPowerBI , Can you elaborate more on the requirements?

    Please post a sample data and output expected for a quick solution

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