Get minimum date drom a measure

[Anonymous]

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

[VahidDM · Accepted solution]

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!! 

LinkedIn | Twitter | Blog | YouTube 

[Uzi2019 · Accepted solution]

hi @Anonymous 

You can try below meaure 

Min_measure= Calculate (min (date), ALL(DELAI))

I hope I answered your question!

[VahidDM · Accepted solution]

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!! 

LinkedIn | Twitter | Blog | YouTube