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.
Hi there,
I am looking to find the time between two points. There is information recorded at the start and again at the end. Example outcome data shown below:
I have tried to create an IF statement but with no success.
Is it possible to create the 'Cycle Time (minutes)' column with this data set?
Any help will be greatly appreciated 🙂
Solved! Go to Solution.
@gregwinter Please try below measure. I'm assuming that you want to find difference in min and max of each serial number
Measure =
VAR _start = CALCULATE(MIN('Table'[Time]),ALLEXCEPT('Table','Table'[Serial No]))
VAR _end = CALCULATE(MAX('Table'[Time]),ALLEXCEPT('Table','Table'[Serial No]))
RETURN IF(MAX('Table'[Sation])=2, DATEDIFF(_start,_end,MINUTE))
@gregwinter Please try below measure. I'm assuming that you want to find difference in min and max of each serial number
Measure =
VAR _start = CALCULATE(MIN('Table'[Time]),ALLEXCEPT('Table','Table'[Serial No]))
VAR _end = CALCULATE(MAX('Table'[Time]),ALLEXCEPT('Table','Table'[Serial No]))
RETURN IF(MAX('Table'[Sation])=2, DATEDIFF(_start,_end,MINUTE))
Brilliant, this works!
Thanks for your effort!
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |