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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Penultimate date of the column

 
Hello, I am trying to create a measure giving me the penultimate date of the column.
It seems simple, written like that, yet I'm breaking my teeth on it

 image.png

 

thank guys

 

1 ACCEPTED SOLUTION

This expression will get you the 2nd highest date in that column.

 

Penultimate Date = var maxdate = MAX(Table[Date_accident])

return CALCULATE(MAX(Table[Date_accident]), Table[Date_accident] < maxdate)

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

4 REPLIES 4
Anonymous
Not applicable

I made a mistake, I wanted the penultimate row in the column

This expression will get you the 2nd highest date in that column.

 

Penultimate Date = var maxdate = MAX(Table[Date_accident])

return CALCULATE(MAX(Table[Date_accident]), Table[Date_accident] < maxdate)

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Very nice solution 👏👏👏

S_JB
Resolver III
Resolver III

This logic should work:

Penultimate Date = MAX(Table[Date_Accident])-1

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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