Forum Discussion
Summaries Table to a Smaller Table
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.
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.
- Hi Expert
I want to create a new table not filter the old table.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