cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Impactful Individual
Impactful Individual

GENERATESERIES with dynamic EndValue

Hello, I have multiple paramterers I want people to be able to change which act as weigthings for a series of measures, but never add to more than 1.

 

I want to make something along the lines of:

 

param1=GENERATESERIES(0, 1, .05)

param2=GENERATESERIES(0, (1-SELECTEDVALUE(param1), .05)

param3=GENERATESERIES(0, (1-SELECTEDVALUE(param1)-SELECTEDVALUE(param2), .05)

...

 

I didnt think it would be as hard as it is. Any ideas on how to do this?

 

Cheers,

 

Sam

// if this is a solution please mark as such. Kudos always appreciated.
5 REPLIES 5
Super User II
Super User II

Hi @samdthompson 

Can you try to explain a bit more what you need? I don't quite get it. An example based on your data would be useful. 

Impactful Individual
Impactful Individual

The first parameter is made with GENERATESERIES(0, 1, .05)

The second and subsequent need to be made with the EndValue being 1-sum of the selected values of the previous generated series. 

 

2019-09-17_6-52-25.png

// if this is a solution please mark as such. Kudos always appreciated.

Hi @samdthompson ,

 

I think you want to create parameters by previous value automitically. Is it right?

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Correct. Is there a way to do that?

// if this is a solution please mark as such. Kudos always appreciated.

Hi @samdthompson ,

 

There isn't a way to do it currently in Power BI. However, you can post your idea here  to make it a feature of Power BI in the future.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors