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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors