Forum Discussion

ashutosh's avatar
ashutosh
Helper I
9 years ago

Need Help with specific requirement

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 ...
Need Help
Show and Tell
Tips and Tricks
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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. :smileyhappy:

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

 

Regards

ashutosh's avatar
ashutosh
Helper I
9 years ago

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.