Forum Discussion

samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
6 years ago
Solved

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: ...
Need Help
  • samdthompson's avatar
    samdthompson
    6 years ago

    Correct. Is there a way to do that?

samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
6 years ago

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. 

 

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi samdthompson ,

 

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

 

  • samdthompson's avatar
    samdthompson
    Icon for Memorable Member rankMemorable Member
    6 years ago

    Correct. Is there a way to do that?

    • v-eachen-msft's avatar
      v-eachen-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      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.