Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Displaying All Time Max

I am trying to write a measure to display the max sales of all time like the below example chart.   Assuming each column is sales for the month but in July 2020 sales was $7.5m, I would like the or...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the reply amitchandak 

To answer your question, Month not Date - I have updated my post to be clear.

Your suggestions return a chart that looks like the below.

 

 

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , I think I forget to add allselected or all

 

calculate( maxx(Values(Calendar[Month-year]), [SalesValue]) , allselected (sales)) //assumes table as sales , ot use all if needed

or

 

calculate(maxx(Values(Calendar[Date]), [SalesValue]), allselected (sales))