Sort Aging Accounts Receivable

Matt:

Thanks for jumping in here. I should have explained my dilemma a little better.

I follow what you are saying about sorting the text column by the sort order column, but my problem goes back to a prior step, i.e., getting the Bills table to "look to" the AR Sort Order table.

I was thinking that I would need to create a colum in the Bills table that incorporates the sort Order field from the AR Sort Order table, the logic of this being: IF(Bills[Aging]='AR Sort Order'[AgingGroup] THEN 'AR Sort Order'[Order]. I have tried to define such a column in the Bills table using the RELATED function, but I am hitting a brick wall.

This may or may not be related. The AR Sort Order table in my data model, which comes from an Excel spreadsheet, shows no rows. Here is how it looks in the Query Editor and then in the table view:

I have tried refreshing the table, but still no rows come into the t