Sorting based on last column

[abukapsoun]

Hi Guys,

Need your support please.

I have the following matrix, How can I sort the table from largest to smallest based on last day values?

Thank you

[v-yadongf-msft · Accepted solution]

Hi @abukapsoun 

This is my test table:

Please create a measure:

Measure = 
var _maxdate=MAXX(ALLSELECTED('Table'),[Date])
var _sum= CALCULATE(SUM('Table'[Value]),FILTER('Table',[Date]=_maxdate))
return
IF(HASONEVALUE('Table'[Date]),SUM('Table'[Value]),_sum)

Create a matrix visual. The column subtotals will become the last day value as below shown, then you can sort from largest to smallest based on last day values:

If you don't want to show column subtotals, you can switch off column subtotals after sorting.

Best regards,

Yadong Fang

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

[Ania26]

Hello, for this measure, if last column has no value then it takes value from previous column. How to adjust measure so if there is no value , there is no value?

[mangaus1111]

Hi @abukapsoun ,

I think that it is not possible to sort a column in a matrix, but it is possible to sort a measure in a matrix. You have to find the way to create a measure only for the last day.