Forum Discussion

Brainer13's avatar
Brainer13
Regular Visitor
5 years ago

How can I obtain the next date after the MIN date?

Hello, I have a visual table that shows the count of distinct dates from customer ordes, but I was asked to put in the the table second date (in case there were changes). 
The first picture shows the original table I had:

Then I used this formula in a measure to get the second date and it worked correctly, but I had 1 order filtered when I created the formula:

Second SSD = Var MinDate =
CALCULATE(MIN('Seguimiento SSD'[Scheduled Date]),ALLSELECTED('Seguimiento SSD'))
Return
CALCULATE(
MIN('Seguimiento SSD'[Scheduled Date]),
FILTER(ALLSELECTED('Seguimiento SSD'),'Seguimiento SSD'[Scheduled Date]>MinDate)
)

After I removed all the filters, I realized that the table is now showing the second date of all the orders, but I want to see the second date of a the order and Item #. How can I change the formula to get the right date?

Thanks,

Brainer 

 

 

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Please provide sample data in usable format (not as a picture) and show the expected outcome.