find maximum and minimum value in filtered value

[Anonymous]

Hi,

i want to use maximum value and minimum value in DAX , how to get maximum and minimum value within the range of filtered value.

Note : If user selects FY 2017-2018 than i want minimum & maximum value in that year range and when he selects Month April of FY 2017-2018 than i want to use maximum and minimum value in that range.

Regards

[Anonymous · Accepted solution]

see sample

https://ufile.io/wplxd

[Stachu · Accepted solution]

in general MIN & MAX are what you need, if you need more specific answer then you need to post anonymised data sample and explain problem and your data model in more detail

is it supposed to for a column or a measure? if a measure then probably you will need to add SUMMARIZE as well to get proper granularity

[Anonymous · Accepted solution]

see sample

https://ufile.io/wplxd