Filtering Cube memory issues

[Anonymous]

I have a sales cube with data starting in 1990.

I want to retrieve the sales from last years with some dimensions. How can I filter the date dimension on the cube file? I'm importing as a SSAS cube.

I add the first dimension

= Cube.Transform(Cube1,
        {
            {Cube.AddAndExpandDimensionColumn, "[Time]", {"[Time].[Date].[Date]"}, {"Time.Date"}}
                    })

then I filter using Power BI table filter tools

Now I want to add the rest of the dimensions/columns to my cube. Is this the right way? Is there a better way to accomplish this? 

[Anonymous]

Also is there some tutorial about cube functions that are available in PowerBI?

[Anonymous]

Anyone?

[Anonymous]

I tried adding first the time dimension, filtering it using Power BI filter tools and then adding other dimensions.. but it doesnt' work

[Jeremy1]

Did you solve this?

Using the V2.0 connector it seems to be possible to filter Cube level data by adding field sequentially instead of in one expression.

so If you add just your year field & one measure in one step.

-Then filter for the desired years.

-Then while on the filtered step click "add items" to bring in more fields & measures. This seems to work and can be multi step i think as in more filters.

Applied steps would then appear

- Source

- navigation

- Added items

- Filtered Rows

-Added items 2

- Filtered Rows 2

etc