GenerateSeries not reading slicer or parameter

[YukonCornelius]

Hi to all.  I'm trying to generate a table of years with a starting point determined by the user.

I've tried a created table of years and a parameter range of values but in both efforts the generateseries formula comes back with the error message: "The arguments in GenerateSeries function cannot be blank."

I searched on this forum and elsewhere under generateseries troubleshooting/slicer, and my blank error message.

I am probably missing something obvious but I can't figure out why the generateseries function isn't creating my table.

The generateseries works if I hard code a year in but I do want this function to be dynamic.  I have checked what few variables there are involved and they are all whole number.

There are no relationships.

I tried initially using a calculated table until I read on this form that generateseries doesn't like calculated tables so I just created a range of years.

I have screen shots of all three views and a simplified pbix with two tabs - one for the slicer reading from a created table of years and one for the slicer reading from the parameter range of years.

I have Sept 2024's Desktop version. 

The three screen shots below are from this file: Simplified GenerateSeries pbix 

Appreciate any thoughts on this.

[lbendlin · Accepted solution]

You can use GENERATESERIES, but only as a temporary table variable within the formula for a measure. The measure itself must return a scalar value.

[YukonCornelius]

Thanks @lbendlin and @Ahmedx.  Appreciate the insight about temporary considerations.  I notice I can generate a non-temporary table series if I use static numbers as the start and end points of the series-unfortunately not useful.  I guess as much as I want to create a dynamic table it is subject to measure considerations.  I'm looking at making a measure with the generateseries as an intermediate step-looks hopeful.  I'll see what comes of it.  Thanks again.

[pbi_dot_edu]

@YukonCornelius , did you ever achieve this? I'm facing a similar issue.

[Ahmedx]

unfortunately power bi does not support this
you can not get the value from the filter to create a table