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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## Finding the first value in column based on date or sequence

Hi everyone

I have a challenge to find the first order number in a table when I apply a date slicer.

The FIRSTNONBLANK() gets me back the first one by sorting them but I don't want to sort them, I need to have the first one based on the date/time column or sequence column.

Thanks

1 ACCEPTED SOLUTION
Super User

@Matt_Gol Try this pattern:

``````Measure =
VAR __Date = MIN('Table'[Date])
VAR __Table = FILTER(ALLSELECTED('Table'),[Date] = __Date)
VAR __Result = MINX(__Table, [Order Number])
RETURN
__Result``````

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
2 REPLIES 2
Helper I

You are a legend @Greg_Deckler , I was thinking too far hahaha

Super User

@Matt_Gol Try this pattern:

``````Measure =
VAR __Date = MIN('Table'[Date])
VAR __Table = FILTER(ALLSELECTED('Table'),[Date] = __Date)
VAR __Result = MINX(__Table, [Order Number])
RETURN
__Result``````

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

## Helpful resources

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors