Summaries Table to a Smaller Table

[Anonymous]

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

[Anonymous · Accepted solution]

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.

[Anonymous]

Hi Expert

I want to create a new table not filter the old table.

[Anonymous]

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