Calculated whole number doesnt sort correctly in matrix

[Anonymous]

Hi,

I have a calculated column with the dax expression and the whole number data type

Days Past = DATEDIFF(INVOICE[PAYMENT_DUE_DATE],TODAY(),day)

If I set this as the first row header in a matrix and click the down arrow to sort it shows

66

62

6

5

4

37

35

Instead of sort it by number values ...any ideas?

Thanks

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, I create a sample and can't reproduce your problem.

Please try to sort the Days Past column by the PAYMENT_DUE_DATE column. Click the Days Past column > Sort by column > PAYMENT_DUE_DATE.

Best Regards,
Community Support Team _ kalyj

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

[amitchandak]

@Anonymous , Make sure the data type and format both are the whole numbers.

You can sort on row/Measure. Column will sort based on the sort order of column used

[Anonymous]

Hi @amitchandak ,

Both are set as whole number and is a in the matrix as a ROW?

TIA