Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated whole number doesnt sort correctly in matrix

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

Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak ,

       

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

       

       

      TIA

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.