Forum Discussion
Show "Most Recent" Value for Matrix Aggregation
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!
2 Replies
- foodd
Community Champion
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!
