Forum Discussion

YukonCornelius's avatar
YukonCornelius
Frequent Visitor
1 year ago
Solved

GenerateSeries not reading slicer or parameter

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 generate...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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.

lbendlin's avatar
lbendlin
Super User
1 year ago

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's avatar
YukonCornelius
Frequent Visitor
1 year ago

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's avatar
    pbi_dot_edu
    Frequent Visitor
    1 year ago

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