cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

## Sorting single value column 'descending' by latest week ending date

Problem: Table needs to be sorted 'descending' for column "3/30/21".  Value is a Dax Measure and latest date changes each week.

Can't seem to find how to do this in visual or through PQ

1 ACCEPTED SOLUTION
Community Support

Hi @kiddknee ,

``````Rank =
IF (
MAX ( 'Table'[Date] ) = MAXX ( ALL ( 'Table' ), [Date] ),
RANKX (
FILTER ( ALL ( 'Table' ), 'Table'[Date] = MAX ( 'Table'[Date] ) ),
,
ASC,
DENSE
),
0
)
``````
``````Sort =
IF (
HASONEVALUE ( 'Table'[Date] ) = FALSE (),
MAXX (
FILTER ( 'Table', 'Table'[Agent Name] = MAX ( 'Table'[Agent Name] ) ),
[Rank]
)
)
``````

The final output is shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support

Hi @kiddknee ,

``````Rank =
IF (
MAX ( 'Table'[Date] ) = MAXX ( ALL ( 'Table' ), [Date] ),
RANKX (
FILTER ( ALL ( 'Table' ), 'Table'[Date] = MAX ( 'Table'[Date] ) ),
,
ASC,
DENSE
),
0
)
``````
``````Sort =
IF (
HASONEVALUE ( 'Table'[Date] ) = FALSE (),
MAXX (
FILTER ( 'Table', 'Table'[Agent Name] = MAX ( 'Table'[Agent Name] ) ),
[Rank]
)
)
``````

The final output is shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

Hey @kiddknee ,

you can choose in the settings of the visual if you want to sort by a specific column and if you want to sort ascending or descending:

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors