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.
Go to Solution.
@Matt_Gol Try this pattern:
VAR __Date = MIN('Table'[Date])
VAR __Table = FILTER(ALLSELECTED('Table'),[Date] = __Date)
VAR __Result = MINX(__Table, [Order Number])
View solution in original post
You are a legend @Greg_Deckler , I was thinking too far hahaha
Find out more about the March 2023 update.
In this session, we'll examine important design issues and decisions that arise when developing with Power BI embedding.