Forum Discussion
find maximum and minimum value in filtered value
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
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
2 Replies
- Stachu
Community Champion
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