I'm using Power Query to connect to a SSAS database and I am trying to make the time portion of the filters dynamic. I need to build a string that looks like this,
[Time].[Time].[Period].&[2017]&[1], [Time].[Time].[Period].&[2017]&[2], [Time].[Time].[Period].&[2017]&[3]
Where the number of elements is dynamic - so if it is March, then the string should look as above, but then in April, it should be
[Time].[Time].[Period].&[2017]&[1], [Time].[Time].[Period].&[2017]&[2], [Time].[Time].[Period].&[2017]&[3], [Time].[Time].[Period].&[2017]&[4]
I have a basic table with my Parameters that looks like this
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Start Year[/TD]
[TD]Start Month[/TD]
[TD]End Year[/TD]
[TD]End Month[/TD]
[/TR]
[TR]
[TD]2017[/TD]
[TD]1[/TD]
[TD]2017[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
But I can't figure out how to turn that into the string needed, repeating for each previous month.
Thanks
[Time].[Time].[Period].&[2017]&[1], [Time].[Time].[Period].&[2017]&[2], [Time].[Time].[Period].&[2017]&[3]
Where the number of elements is dynamic - so if it is March, then the string should look as above, but then in April, it should be
[Time].[Time].[Period].&[2017]&[1], [Time].[Time].[Period].&[2017]&[2], [Time].[Time].[Period].&[2017]&[3], [Time].[Time].[Period].&[2017]&[4]
I have a basic table with my Parameters that looks like this
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Start Year[/TD]
[TD]Start Month[/TD]
[TD]End Year[/TD]
[TD]End Month[/TD]
[/TR]
[TR]
[TD]2017[/TD]
[TD]1[/TD]
[TD]2017[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
But I can't figure out how to turn that into the string needed, repeating for each previous month.
Thanks