Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

undefined

Hi everyone, I want to create a measure which shows the day of the week with the highest amount of customers. Unfortunately, the DAX-function MAX doesn't work here. Our customers have ID-numbers....

Need Help

Nishantjain
7 years ago
You can use TopN and RankX to get the day with highest customer visits.

Use RankX to rank the days using the current measure that you have. You can then use the TopN function to get the top day.

Thanks

Nishantjain

Continued Contributor

7 years ago

You can use TopN and RankX to get the day with highest customer visits.

Use RankX to rank the days using the current measure that you have. You can then use the TopN function to get the top day.

Thanks

Anonymous

Not applicable

7 years ago

Hi Nishantjain and Ashish_Mathur ,

Thank you for your respons and interest. The Rankx formula was the one I needed. Maybe I need to fine tune the tables (and thus some formulas) in the future, but for no it is sufficient.

Thanks.