Forum Discussion
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....
- 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
Hey Anonymous !
I'm not too sure what part of the data model you are trying to use to arrive at your desired outcome.
Obviously, you have some table that display days of the week, & some table with customer ids.
Which customer activity are you wanting to track during the weekdays? Are they filling out surveys? Are they visiting your location? Are they purchasing items?
Do you have sample data you can provide?