Forum Discussion

JDartz's avatar
JDartz
Frequent Visitor
4 months ago
Solved

Issues with First/Last Sorting on Matrix Table Column

I have a Matrix Table Column that seems to be sorting inconsistently for a column of data.   Essentially, I have a column of text that is capturing a number and I need the last number of the sub-ro...
Need Help
  • parry2k's avatar
    parry2k
    4 months ago

    JDartz here is the measure, change the column and table name as per your model, use display value measure in the matrix.

     

    Sum = SUM ( YourTable[YourColumn] ) 

DIsplay Value = 
IF ( 
    ISINSCOPE ( 'YourTable'[Date] ), [Sum],
    LASTNONBLANKVALUE ( 'YourTable'[Date], [Sum] )
   
)

     

  • mickey64's avatar
    mickey64
    4 months ago

    For your reference.

     

    Step 0: I use these DATA below.

     

    Step 1: I Make a Measure and a Matrix below.

    M_LastDateValue = CALCULATE(MAX('DATA'[No]),FILTER('DATA','DATA'[Date]=CALCULATE(MAX('DATA'[Date]),ALLEXCEPT('DATA',DATA[Office Name]))))

     

     

     

     

     

     

v-echaithra's avatar
v-echaithra
Community Support
3 months ago

Hi JDartz ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.