Highest Sales week

[joshua1990]

I have a matrix that shows me the sales for each week.

Now I would like to add a second column that shows me the best week/ the highest sales.

But how?

[v-jayw-msft]

Hi @joshua1990 ,

The highest sales:

MAXX(FILTER(ALL(Table),[week]=SELECTEDVALUE([week])),[sales each week])

The best week:

CALCULATE(MAX([week]),FILTER(ALL(Table),[sales each week]=[highest sales]))

If I misunderstand your meaning, please show some sample data and expected result to us.

Best Regards,

Jay

[AlexisOlson]

Some example data and expected results would make this much easier to answer.

How to Get Your Question Answered Quickly