Show "Most Recent" Value for Matrix Aggregation

[CoopyJoe]

Hi, I was hoping to display the "most recent" or "last" value for my matrix visualization. I have attached an example of my current matrix, and how I would ultimately like to look. Is there a way to show other summarizations than sum, average, minimum, maximum, count (distinct), count, standard deviation, variance, or median? Thanks!

[foodd]

Yes, there is!    I don't have a moment to add an example, though it works quite well.

The following Enterprise DNA content will help you to get started:

EnterpriseDNA Blog:  Creating Power BI Tables By Using UNION & ROW Function

EnterpriseDNA Video:  How To Create Tables By Combining UNION and ROW Functions In Power BI [2023 Update]

Using this approach allows you to create a pivot that is a UNION of one or more tables with one or more ROWS.  When I get a chance, I will build a solution file unless one of the other folks here does.

Please do share your working solution by adding it to this thread so that others who search can benefit from it.  Good luck!

[CoopyJoe]

@foodd thanks so much for the response. Yes, I would love to see an example. Unfortunately I cannot attach my working example, as it contains sensitive information. Thank you!