Need Help with specific requirement

[ashutosh]

Hello Everyone,

I have one specific requirement in my project.

I have two dates for different shipments:

1. First In Transit

2. Delivered of First Mile

So I have to create a measure in which I have to find if 'First In Transit' event is greater than or equal to 4 days from now (today's date) and 'Delivered of First Mile' is empty i.e, No delivery event. It should give me some result like 'Not Delivered Yet'.  Please have a look at the screenshot for more info.

[v-ljerr-msft]

Hi @ashutosh,

Based on my test, you should be able to use the formula below to create a new measure and show it on the report in this scenario. 

Measure =
IF (
    TODAY () - MAX ( Table1[First In Transit] )
        <= 4
        && ( ISBLANK ( MAX ( Table1[Delivered of First Mile] ) ) ),
    "Not Delivered Yet"
)

Regards

[ashutosh]

@v-ljerr-msft Hi,

Thank you for your response. Could you please elaborate (for my understanding) why you selected MAX. 

The condition here is, I need to show 'Not Delivered Yet' only to those ID's which have First in Transit Event more than 4 days from now and Delivered of first Mile is empty. And I have to consider only working days i.e. Mon to Fri.

[ashutosh]

####

[ashutosh]

@Greg_Deckler , @v-shex-msft Please, could you help me out here.