Delivery indicators classification

[Anonymous]

Hi there,

I have a table with the following values:

LatestDateToBeDelivered | ActualDateOfDelivery | LateDeliveryIndicator

          03/01/2019                       03/01/2019                                  1

          04/01/2019                       03/01/2019                                  1

          07/01/2019                       28/01/2019                                  5

          19/01/2019                       14/01/2019                                  3

          22/01/2019                       26/01/2019                                  4

          15/02/2019                       17/02/2019                                  2

What I want to get is classification of these Late Deliveries in a way that I could split them as following: not late = 1, 1-3 days late = 2, 4-7 days late = 3, 8-15 days late = 4 and 15 or more days = 5. For now, I only have first two columns.

What I already used, was this, and it worked perfectly -> https://community.powerbi.com/t5/Desktop/Measure-on-time-delivery-performance-and-slice-by-origin/m-...

However, now I would like to say more about it than Late or On-time since being a day or two late is not a big deal, but being late more than a week is an alarm.

Anybody had a similar issue?

[v-cherch-msft]

Hi @Anonymous 

You may add a measure to get LateDeliveryIndicator>=3 or other values like below.Then use it in visual level filter to get the alarm.

Measure = IF([LatestDateToBeDelivered]>=3,1)

Regards,

Cherie

[Anonymous]

Hi Cherie,

Many thanks for your reply and time to explain. However, this solution does not work for me at all. When I try to create a new measure with the formulae you provided, the result I get is ''A single value for column 'LatestDateToBeDelivered' in table 'XY' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count or sum to get a single result."

Wouldn't it make more sense to make it similar to your but with the full formula expression where I can say something like this:

IF([LatestDateToBeDelivered] >=  [ActualDateOfDelivery], >= 3, 1)

Sorry for my bad DAX skills, but I would read this if latest date to be delivered is greater or equal to actual date of delivery, for the value of 3, then classify as 1. Does this make sense?

[v-cherch-msft]

Hi @Anonymous 

You may try below measure with DATEDIFF function.Then use it in filter.

Measure =
IF (
    DATEDIFF (
        SUM ( Table1[LatestDateToBeDelivered] ),
        SUM ( Table1[ActualDateOfDelivery] ),
        DAY
    ) >= 3,
    1
)

Regards,

Cherie

[Anonymous]

Hi @v-cherch-msft ,

Unfortunately, this does not help either. Although, I did manage to use DATEDIFF function to retrieve some values back in the form I would like them. Many thanks for your help!

[v-cherch-msft]

Hi @Anonymous 

Could you share some data sample and expected output?You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Cherie