Forum Discussion
radu92
Helper I
Helper IFind the next higher value after MIN
Hi everyone, I have the following dataset: Case Nr. Incident Date 1 randomstring 1.1.2016 1 randomstring 2.1.2016 1 randomstring 5.1.2016 2 randomstring 3.1.2016...
Thiyags
Helper II
Helper IIIs this wat you are expecting.
You can use the below formual
2ndMinDate = CALCULATE(MIN(Sheet6[Date].[Date]), filter(Sheet6, Sheet6[Date].[Date]<>MIN(Sheet6[Date])))
radu92Thanks! This is exactly what I've been looking for. Do you know how I can make this a column instead of a measure? Like having a column with this value for all case numbers?
- Thiyags
I am not sure.
But there is a video in the below link on columns vs measures
https://projectbotticelli.com/knowledge/dax-calculated-columns-vs-measures-video-tutorial