Forum Discussion
Summaries Table to a Smaller Table
Hi Experts
How would you summarise the following table as shown below into a small table in to refect only month 1-12. i.e.
With the most recent date first and so...
months | Date | ComplaintsPer Mionth
1 | 01/06/2019 | 4172 and so on
2
3
4
5
6
I'm guessing you want to see only the trailing 12 months (in your below an index of 1-12)? If so, just put in a range filter in your visual to select on the index column and set it to <13?
if you want to set it up in your table to filter the rows instead of in the visual, you can filter the index column as well, something like this:
= Table.SelectRows(#"PriorStepName", each ([Index] < 13))
Unless your data table is huge, I'd do the selection/filtering on the visual vs. the table, so that you have the ability to view various ranges more easily.
3 Replies
I'm guessing you want to see only the trailing 12 months (in your below an index of 1-12)? If so, just put in a range filter in your visual to select on the index column and set it to <13?
if you want to set it up in your table to filter the rows instead of in the visual, you can filter the index column as well, something like this:
= Table.SelectRows(#"PriorStepName", each ([Index] < 13))
Unless your data table is huge, I'd do the selection/filtering on the visual vs. the table, so that you have the ability to view various ranges more easily.
you can use the "group" function. This effectively summarizes tables into "smaller" tables based on the critera you specify. Here's a primer on how to use it:
https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning