Forum Discussion
bdeleur
3 years agoHelper III
Unique value count only at start date
Hi, I have a datebase and I need to count only the first row of the unique reference. So it looks like this: Reference Start date 1 1-1-2023 17:00 2 1-1-2023 16:23 1 12-1-202...
- 3 years ago
Hi, bdeleur
You can try the following methods.
Column = Var _count= CALCULATE(COUNT('Table'[Reference]),ALLEXCEPT('Table','Table'[Start date])) Var _mindate=CALCULATE(MIN('Table'[Start date]),ALLEXCEPT('Table','Table'[Reference])) Return IF([Start date]=_mindate,_count,BLANK())Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bdeleur
3 years agoHelper III
Anybody an suggestion?