cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ikezaki
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:
OCCURENCE =
COUNTX (
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.
3 REPLIES 3
Ikezaki
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.

PhilipTreacy
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.

regards

Phil



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

Announcements
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