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

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!