Forum Discussion
FIND MAX AND MIN
Hi,
I have table named: "Data Model", which contain columns as follows:
Date , Category , Subcategory , Cost, Kg.
Another "Date" table which contain colums as follows:
Date, Week, Month, Year.
Need to find max value of cost / kg in a week and min value of cost / kg in a week .
i tried but it is showing the same cost value as min value.
eg: for week 1 it should show 0.02 as min and 1.38 as max in all the rows .
Hi PriyamKanojia ,
What's the formula of fields which you apply the Values Fields of matrix? Could you please provide some sample data(exclude sensitive data) and the matrix settings for further investigation? Thank you.
In addition, I created a sample pbix file(see the attachment), please check if that is what you want.
Best Regards
3 Replies
Hi PriyamKanojia ,
What's the formula of fields which you apply the Values Fields of matrix? Could you please provide some sample data(exclude sensitive data) and the matrix settings for further investigation? Thank you.
In addition, I created a sample pbix file(see the attachment), please check if that is what you want.
Best Regards
Anonymous
can you help me in max and min measure.
I can't find max of cost/kg and min of cost/kg.
Anonymous
Attaching the data screenshoot and what i want below.
I have highlighted the max and min of each week in the table.
