Hello,
I am currently trying to get the absolute percentage difference between 2 time values, but I'm struggling to get it to work.
I have this table:
I need the following calculation: Run_Time/SFI_Total_Posted_Run_Time x 100
However the calculation I use doesnt work:
Solved! Go to Solution.
@kelly008 , you have to create a measure like
Divide(
SUM(RoutingLinesNew[Run_Time]),
SUM(routinglinesnew[sfi_total_posted_run_time]))
and mark that as % column
Please remember the two are not equal
Run_Time/SFI_Total_Posted_Run_Time <>
Divide(
SUM(RoutingLinesNew[Run_Time]),
SUM(routinglinesnew[sfi_total_posted_run_time]))
@kelly008 , you have to create a measure like
Divide(
SUM(RoutingLinesNew[Run_Time]),
SUM(routinglinesnew[sfi_total_posted_run_time]))
and mark that as % column
Please remember the two are not equal
Run_Time/SFI_Total_Posted_Run_Time <>
Divide(
SUM(RoutingLinesNew[Run_Time]),
SUM(routinglinesnew[sfi_total_posted_run_time]))
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
78 | |
69 | |
55 | |
55 |
User | Count |
---|---|
200 | |
104 | |
85 | |
80 | |
77 |