Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
pcda
Helper I
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 DeliveryReal Delivery
10/08/202207/08/2022
11/08/202210/02/2022
12/08/202225/10/2022
13/08/202231/07/2022
14/08/202228/08/2022
15/08/202215/08/2022
16/08/202216/09/2022

 

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

 

Thank you very much!

1 ACCEPTED SOLUTION
parry2k
Super User
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 () )
)

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

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.

View solution in original post

2 REPLIES 2
pcda
Helper I
Helper I

Thank you @parry2k ! Worked like a charm

parry2k
Super User
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 () )
)

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.