cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

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

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors