Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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......
Solved! Go to Solution.
@YcnanPowerBI , try this in a measure
Total Time = FORMAT(TIME(0,[1 Tickets Created] * 5,0),"hh:nn:ss")
@YcnanPowerBI , Can you elaborate more on the requirements?
Please post a sample data and output expected for a quick solution
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 Created | Total Time |
4 | 0:20:00 |
2 | 0:10:00 |
6 | 0:30:00 |
8 | 0:40:00 |
1 | 0:05:00 |
@YcnanPowerBI , try this in a measure
Total Time = FORMAT(TIME(0,[1 Tickets Created] * 5,0),"hh:nn:ss")
Worked great! Thank you for your time!
Glad that it worked, cheers!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
86 | |
71 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |