urgent-get the max value per attribute

[gaikwadaa123]

Hello,

This platform has been always a great help for me. I am looking for one more urgent solution;

I have table that looks like below 

The Measurement name has three rows DEC area,, DEP area, DOM area, then there is value, Date and month column,

I would like to calculate the Max value  for each DEC area, DEP area, DOM area by each month. 

so that there will be new column as maxvalue. and it will have max for  DEC area,, DEP are, DOM area for each month. 

I am looking for custom  column .

thank you in adavnce.

[mhossain]

@gaikwadaa123 

See this blog and follow the instruction, I think this is what you are looking for:

http://dataap.org/blog/2019/12/19/min-and-max-value-in-power-query-power-bi/

[gaikwadaa123]

This worked like charm. Thank you so much.

[pranit828 · Accepted solution]

Hi @gaikwadaa123 

I would use the below DAX for the above requirement.

_max = CALCULATE(MAX(table[value]), ALLEXCEPT(table,table[Month]))

If this doesn't work you will have to provide more details about how your MeasurementMeasure is calcualted and if you have sum or average in the value column based on the measure.

[gaikwadaa123]

thank you for the response, instead of the dax can we do custome column ?

do you know anyway to add that way?