Find minimum value on table measure

[leandroduarte]

Dear Colleagues,

I'm trying to find the minimum year in a table and I would like to have a measure as result for the minimum value

I want to keep the table in the following display and result of the year always showing 2011

Year	Min Year = Expected measure results
2011	2011
2012	2011
2013	2011
2014	2011

[Ashish_Mathur]

Hi,

Try this meaure

=MINX(ALL(Calendar),Calendar[Year])

Hope this helps.

[v-yangliu-msft]

Hello toleandroduarte,

Here are the steps you can follow:

1. You can create a measure to solve

min_measure = 
CALCULATE(MIN('Table'[Year]),ALL('Table'))

2. You can create a column to solve

min_column = 
MIN('Table'[Year])

3. Result.

Best regards

Liu Yang

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[AlB]

Hi @leandroduarte 

Measure =
CALCULATE ( MIN ( Table1[Year] ), ALL( Table1[Year] ) )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers