Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help! Measure for the following condition -

I have two columns: Start Date            End Date       a                                a1       b                                b1       c                                c1       d          ...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Anand_

I am not clear about your problem, did you want to create another column to show Yes or No based on the condition?

Start Date            End Date        new column

      a                                a1        Y  (a>a1)

      b                                b1       Y   (b>a1 )

      c                                c1       N   (c>a1, c<b1)

      d                                d1       Y   (d> a1,d>b1,d>c1)

If not, please inform me more detailed ifnormation(such as your other conidtion, and your expected output)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your reply.

     

    So, I have a number - 'x' .

     

    Start Date            End Date        

        a                                a1                   if  (b<a1)

     

        b                                b1                  Y   - if (c<a1 && c<b1)                           [N - a1 is eliminated and begins with next set  - If ( c<b1)]

      

        c                                c1                   Y   - if (d<a1 && d<b1 && d<c1)     [N - Smallest (a1 or b1 - Let's say a1) is eliminated - if (d<b1 &&d<c1)]

     

        d                                d1                  Y    - and so on..

     

    If No - the condition starts from the beginning with the smallest end dates set (both a and a1) getting eliminated.

     

    My expected result would be the difference between a start date and another date.

     

    I would stop the loop and give the result (difference) when I get 'x' - Yess'.

     

    I know it's a bit confusing but any help is much appreciated.

     

    Thanks!