Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Brainer13
Regular Visitor

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:

Brainer13_0-1627597133227.png

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

Brainer13_1-1627597223904.png

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?

Brainer13_2-1627597438729.png

Thanks,

Brainer 

 

 

1 REPLY 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (27)