Since the column being ranked is a text, Power BI sorts its items alphabetically. So I use day of week to custom sort the day names. The above formula works fine if the Day Name column is sorted by itself but returns 1 if sorted by day of week.
Image 1 - Day Name is sorted by Day of Week Number, Image 2 - Sorted by itself
I would greatly appreciate your help.
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand." www.linkedin.com/in/danebelarminocpa