Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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]))
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.