Forum Discussion
CyrilV
6 years agoRegular Visitor
Calculate MIN DATE
Hy,
I Try to calculate a MIN Date of my selection.
I want on my column _minDate the value 02/01/2018
Measure :
_minDate = calculate(min(GRS_RESERVATION[_date]);ALLSELECTED(GRS_RESERVATION[_date]))
Thanks you in advance.
2 Replies
- amitchandak
Super User
have you tried?
_minDate = calculate(min(GRS_RESERVATION[_date]);ALL(GRS_RESERVATION[_date]))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601 - v-joesh-msft
Solution Sage
Hi CyrilV ,
You can try the following measure:
_minDate = calculate(min(GRS_RESERVATION[_date]);ALLSELECTED(GRS_RESERVATION))Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.