How to generate series based on measure values

[Anonymous]

Hi, 

I've created a measure and i would like to create a what-if parameters based on values of "delai ". 

How can I generate series in function of values calculated by my measure?

here, my measure range is between -59 and 273. But, that measure is updated everyday so the range could change (for example, -70 to 300) 

Thank you for your help,

Andre

[amitchandak]

@Anonymous , I was able to create a new table based on another table

Table = GENERATESERIES(min(Customer[Age]) ,max(Customer[Age]))

[Anonymous]

@amitchandak it doesn't work because my values come from a measure. Not a value from a table.

[CNENFRNL]

@Anonymous Since you have already definitive range, why not generate a series directly?

Range Table = GENERATESERIES( -70, 300 )

[Anonymous]

Hi @CNENFRNL ,

I would like to generate a table dynamically.

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

Would you please try the calculated table below:

Range Table =
GENERATESERIES (
    MINX (
        SUMMARIZE ( 'Table', 'Table'[Column], "_measure", [measure] ),
        [_measure]
    ),
    MAXX (
        SUMMARIZE ( 'Table', 'Table'[Column], "_measure", [measure] ),
        [_measure]
    )
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai