Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a column of datetime data and I am trying to select the first date after filtering the table. I am using the following calculated column formula:
Solved! Go to Solution.
Can you not just use MIN?
CALCULATE(MIN('Table'[Date].[Date]), FILTER('Table', 'Table'[TestID] = 'Table2'[TestID]))
Can you not just use MIN?
CALCULATE(MIN('Table'[Date].[Date]), FILTER('Table', 'Table'[TestID] = 'Table2'[TestID]))
this did the trick, thank you!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |