Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.
Need Help

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    PhilipTreacy  Hi Philip, 

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

     

    Thank you for the reply.

     

    • v-robertq-msft's avatar
      v-robertq-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi, Anonymous 

      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.