cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Calculating Difference of Dates and KPI visual of % in time

Hi everyone! I'm having a bit of a problem displaying a visual of a percentage of on-time deliveries. I have 2 columns: Estimated Delivery Date and Real Delivery Date. If Real Delivery Late < Estimated Delivery Date, then the delivery was done on time.

Then, the total deliveries in time divided by total deliveries should be equal to the % of On-Time Deliveries and I should be able to place that in a Card visual.

I tried using a meassure with DATEDIFF and then another one with an IF, but it is not counting as I expect it to. Anyone knows a workaround for this?

The table looks like this:

 Estimated Delivery Real Delivery 10/08/2022 07/08/2022 11/08/2022 10/02/2022 12/08/2022 25/10/2022 13/08/2022 31/07/2022 14/08/2022 28/08/2022 15/08/2022 15/08/2022 16/08/2022 16/09/2022

For this example, the visual should display "43%".

Thank you very much!

1 ACCEPTED SOLUTION
Super User

@pcda this is what I will do, first add a column to flag if delivery is on time or late and then add a measure to show in the visual

``````Delivery Status Column =
IF ( Table[Real Delivery Date] < Table[Estimate Delivery Date], "OnTime", "Late" )

Count Measure = COUNTROWS ( Table )

On Time % Measure =
DIVIDE (
CALCULATE ( [Count Measure], Table[Delivery Status Column] = "OnTime" ),
CALCULATE ( [Count Measure], ALL () )
)``````

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

2 REPLIES 2
Helper I

Thank you @parry2k ! Worked like a charm

Super User

@pcda this is what I will do, first add a column to flag if delivery is on time or late and then add a measure to show in the visual

``````Delivery Status Column =
IF ( Table[Real Delivery Date] < Table[Estimate Delivery Date], "OnTime", "Late" )

Count Measure = COUNTROWS ( Table )

On Time % Measure =
DIVIDE (
CALCULATE ( [Count Measure], Table[Delivery Status Column] = "OnTime" ),
CALCULATE ( [Count Measure], ALL () )
)``````

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.