Forum Discussion

Cayshin's avatar
Cayshin
Frequent Visitor
5 years ago
Solved

Multi-row Matrix, when collapsed, how to show the LAST entry values?

I have a Maxtrix built from data based on when a Client visits. The Rows are organized by "Client Name" then "Visit Date". Columns being what's shown. When expanded, the Rows look like this: ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi Cayshin ,

     

    Try the following measures:

     

    Latest Visit Date = MAX('Table'[Visit Date])
    Last Weekday = MAXX( FILTER( 'Table', 'Table'[Visit Date] = MAX('Table'[Visit Date]) ), 'Table'[Weekday] )
    Last Visit Time = MAXX( FILTER( 'Table', 'Table'[Visit Date] = MAX('Table'[Visit Date]) ), 'Table'[Visit Time] )
    Last Visitors = SUMX( FILTER( 'Table', 'Table'[Visit Date] = MAX('Table'[Visit Date]) ), 'Table'[Visitors] )

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

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

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Cayshin ,

 

Try the following measures:

 

Latest Visit Date = MAX('Table'[Visit Date])
Last Weekday = MAXX( FILTER( 'Table', 'Table'[Visit Date] = MAX('Table'[Visit Date]) ), 'Table'[Weekday] )
Last Visit Time = MAXX( FILTER( 'Table', 'Table'[Visit Date] = MAX('Table'[Visit Date]) ), 'Table'[Visit Time] )
Last Visitors = SUMX( FILTER( 'Table', 'Table'[Visit Date] = MAX('Table'[Visit Date]) ), 'Table'[Visitors] )

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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