Forum Discussion
YukonCornelius
1 year agoFrequent Visitor
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...
- 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
1 year agoFrequent Visitor
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
1 year agoFrequent Visitor
YukonCornelius , did you ever achieve this? I'm facing a similar issue.