Mdx query to display data in monthwise

See more:

MDX

I am using mdx query to bind charts in month wise, if I am using in the following way

select
{ [Measures].[MetricRatio],[Measures].[Average]} on 0,
{ Filter( LastPeriods(3, [Time].[All Time].[2017].[Quarter 1].[January].[19].parent), true ) } on 1

By using lastperiods with .Parent it was not considering the date. It was getting for the complete january month data.

Actually i should get the data as oct 22 to Jan 19.
Oct : 22 - 31
Nov : 01 - 30
Dec : 01 - 31
Jan : 01 - 19

But it was getting as
Actually i should get the data as oct 22 to Jan 19.
Oct : 01 - 31
Nov : 01 - 30
Dec : 01 - 31
Jan : 01 - 31


If I am removing parent from the mdx query, it was getting october 22 to January 19 which is correct, but displaying in day wise. But I need in monthwise.
select
{ [Measures].[MetricRatio],[Measures].[Average]} on 0,
{ Filter( LastPeriods(3, [Time].[All Time].[2017].[Quarter 1].[January].[19]), true ) } on 1

Please kindly help me, if anybody knows the solution.

What I have tried:

mdx query to display data in monthwise

select
{ [Measures].[MetricRatio],[Measures].[Average]} on 0,
{ Filter( LastPeriods(3, [Time].[All Time].[2017].[Quarter 1].[January].[19].parent), true ) } on 1