Forum Discussion
joannasokolowsk
Helper II
Helper IIMAX/MIN measure
Hi all, I need a help with MAX/MIN measure which will be checking the max/min sum of number of hours per person (by category). For example, based on below datasat the max sum number of hours per p...
joannasokolowsk , Try one of the two
minx(values(Table[name]), calculate(sum(Table[length in hours])))
or
minx(Summarize(Table,Table[category],Table[name]"_1", calculate(sum(Table[length in hours]))),[_1])
amitchandak
Super User
Super Userjoannasokolowsk , Try one of the two
minx(values(Table[name]), calculate(sum(Table[length in hours])))
or
minx(Summarize(Table,Table[category],Table[name]"_1", calculate(sum(Table[length in hours]))),[_1])
joannasokolowskHelper II
Helper IIPerfect! it works!!!
Have a great day!