Hi , How to find maximum value for each year?

[ShaRaj]

state	Year	Category	value
a	2015	P	10
a	2017	p	20
a	2018	p	30
b	2015	p	40
b	2017	p	50
b	2018	p	60

For each year i need to find the minimum value.

Thanks in Advance.

[FreemanZ]

hi @ShaRaj 

you can plot a table visual with year column and a measure like this:

Measure = MAX(TableName[Value])

or you can create a calculated table with this:

Table =
ADDCOLUMNS(
    VALUES(TableName[Year]),
    "MaxValue",
    CALCULATE(MAX(TableName[Value]))
)

[ShaRaj]

ok,What is the formula if i have different category like

Country	Year	Category	value
Aus	2015	P	10
Aus	2017	p	20
Aus	2018	p	30
Braz	2015	p	40
Braz	2017	p	05
Braz	2018	p	60
Aus	2015	q	35
Aus	2017	q	15
Aus	2018	q	25
Braz	2015	q	47
Braz	2017	q	25
Braz	2018	q	9
Aus	2015	r	15
Aus	2017	r	9
Aus	2018	r	4
Braz	2015	r	22
Braz	2017	r	21
Braz	2018	r	25
Aus	2015	s	13
Aus	2017	s	17

so, i want answer like 2015 p (minvalue), 2015  q min value,2015 r min value.....

2017 p,q,r minimum values....

.

[FreemanZ]

hi @ShaRaj 

the similar measure:

Measure = MIN(TableName[Value])

but plot the table with year and category columns.

[FreemanZ · Accepted solution]

hi @ShaRaj 

like this:

or, result as calculated table, like this:

[ShaRaj]

hi, how can i substract these minimum to each value corrspondingly ie, country category wise

like

for each state  for "p" category  value minus minmum