Data extract from BI Query date range not available

[AleksP]

Hello Team, 

I have a BI query which in main variable filters has only one single selection of period. 

But I need to extract a range of periods. For Example last 12months .. and its not relevant to create 12 queries with different periods.
Is there any smarter solution on this?

let
Source = SapBusinessWarehouse.Cubes("****************", "11", "111", [Implementation="2.0"]),
123456 = Source{[Name="**************"]}[Data],
#"************************" = 123456{[Id="************************"]}[Data],
#"Added Items" = Cube.Transform(#"*******************************",
{
{Cube.ApplyParameter, "[!V000001]", {{"[0FISCPER].[A12023001]"}}},
{Cube.AddAndExpandDimensionColumn, "[0CALWEEK]", {"[0CALWEEK].[LEVEL01]"}, {"Cal Week/Year.Cal Week/Year Level 01"}},
{Cube.AddAndExpandDimensionColumn, "[0FISCPER]", {"[0FISCPER].[LEVEL01]"}, {"Fisc Period/Year.Fisc Period/Year Level 01"}},
{Cube.AddAndExpandDimensionColumn, "[0MATERIAL__ZPRODH2]", {"[0MATERIAL__ZPRODH2].[LEVEL01]"}, {"Category.Category Level 01"}},
{Cube.AddMeasureColumn, "GR #(cr)#(lf)Pallets", "[Measures].[4HQA6L7D8VFRHSJ883BZ88U1M]"}
})
in
#"Added Items"

[edhans]

We need to see data. We have no idea what your SAP Cubes look like.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.