cancel
Showing results for
Did you mean:
Anonymous
Not applicable

How to generate series based on measure values

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)

Andre

1 ACCEPTED SOLUTION
Community Support

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

5 REPLIES 5
Super User

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

``Table = GENERATESERIES(min(Customer[Age]) ,max(Customer[Age]))``
Anonymous
Not applicable

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

Super User

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

``Range Table = GENERATESERIES( -70, 300 )``

 Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! DAX is simple, but NOT EASY!
Anonymous
Not applicable

Hi @CNENFRNL ,

I would like to generate a table dynamically.

Community Support

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

Announcements

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors