Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
thank guys
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Very nice solution 👏👏👏
This logic should work:
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |