Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
Ive been trying for hours now to find the right way. But I can't.
I want to calclulate the share of parcels delivered on time.
I have a table, where the count of rows is my total.
Ex.:
ParcelNumber - CompletionDiffDays
12456 - 1
11123 - 0
13246 - 0
Co I want to count rows/ParcelNumber as total. Then all rows <0 = On time, the rest is delayed.
So this example would be 3 total, 1 delayed, 1 on time. So I want a card to display 66,6% on time.
But how to write the calculation?
Solved! Go to Solution.
I found out:
I found out:
Hi @DennisSchlein ,
Your requirement is not very clear, especially the formula. Could you please give a proper example?
Hi
I have made this simple sample dataset.
So I want to count destinct tracking number - as total.
In this case, 28. Then all the parcel numbers with a CompletionDiff less or equal to 0 is on time.
So the on time share of the total? (sorry for the picture. I cannot figure how to insert two coloumns from excel and format it correctly.
Kind regards
Was thinking something like this could have worked, but it doen't: