Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
2 | randomstring | ... |
3 | randomstring | ... |
4 | randomstring | ... |
4 | randomstring | ... |
4 | randomstring | ... |
I would like to group this table by case nr., and choose the 2nd date after the earliest one.
Any ideas how I can do this?
Thanks in advance!
Solved! Go to Solution.
Is 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])))
Is 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])))
Thanks! 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?
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
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |