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

 

 

 

 

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • 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.