Forum Discussion
ellevy
Helper I
Helper Ifind max value per week
Hi all
i am struglling with this.. probably very easy .... i want to show chart of week numbers (1..52) on the x-axis and put values of the max value i have per week
for example if for week number 2 i have 3 values (10,50,100) i want to show 100 for this week (number 2). just by using max function i get strange results ...
help appreciate
Elad
ellevy , Create week in you calendar and take max .
if you want, to sum up max try like
Week Max = max(Table[Column])
Sum Week Max = Sumx(Values(Date[Week]),[Week Max])
Also, refer my Blog
3 Replies
- amitchandak
Super User
ellevy , Create week in you calendar and take max .
if you want, to sum up max try like
Week Max = max(Table[Column])
Sum Week Max = Sumx(Values(Date[Week]),[Week Max])
Also, refer my Blog
