Forum Discussion
Get minimum date drom a measure
I have a table that looks like this.
with a date measure that basically takes the minimum date based on the delay.
What I need is to have a minimum of these dates that will populate the whole table, so it looks like this:
Any idea on how to fo it?
Thanks
Hi Anonymous
Try this measure
Date_Min = CALCULATE ( MIN ( 'table'[date 1] ), REMOVEFILTERS ( 'Table' ) )You can remove filters only from DELAI column rather than the whole table as well.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
hi Anonymous
You can try below meaureMin_measure= Calculate (min (date), ALL(DELAI))
I hope I answered your question!
2 Replies
Hi Anonymous
Try this measure
Date_Min = CALCULATE ( MIN ( 'table'[date 1] ), REMOVEFILTERS ( 'Table' ) )You can remove filters only from DELAI column rather than the whole table as well.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
hi Anonymous
You can try below meaureMin_measure= Calculate (min (date), ALL(DELAI))
I hope I answered your question!