Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Set 99% as target date

Hi everyone,


I have a table with the following dates "Ship by Date" "Shipped Date", I have create a column called Shipment Status with the following formula:

SHIPMENT_STATUS = if ('Export Worksheet'[SHIP_BY_DATE] <= 'Export Worksheet'[SHIPPED_DATE], "On Time", "Delayed")
Also I created a counter to see how many times the shipments are on time or delayed:
FILTER ( 'Export Worksheet', EARLIER ( 'Export Worksheet'[SHIPMENT_STATUS] ) = 'Export Worksheet'[SHIPMENT_STATUS] ),
'Export Worksheet'[SHIPMENT_STATUS])
I have to set a target where 99% of the shipments are on time. The report I am trying to build is a Table with the following information.
Department | Count of how many times the shipments are on time | The total of shipments (including on time+ delayed) | % of on time shipments
Thank you in advance.
Frequent Visitor

@PhilipTreacy  Hi Philip, 

Sorry for the late reply. I have solved this issue.


Thank you for the reply.


Hi, @Ikezaki 

Glad to hear that you have solved the problem by yourself, would you like to share some experience or just mark your own reply as a solution?

Thanks in advance!

How to Get Your Question Answered Quickly 


Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

Hi @Ikezaki 

Can you provide some sample data? Otherwise it has to be recreated rom nothing and that takes time and may not accurately reflect your real data.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors