The below is the table I am working with, and I want to rank by week ending date.
I am trying to formula :
Week Rank = RANKX(All('Table 1'),'Table 1'[week ending date],,ASC,Dense)
But I get the error:
A single value for column 'week ending date' in table 'Table 1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
The week ending dates look like the below, so I don't understand why it isn't working. Any help appreciated!