Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |