Edit what if param

[BarSi1986]

Dear Comunity,

I created What If parameter, but after 2 weeks of production usage there is a need to change its incrementation,

now it increments by 100 but need to change step to 1 ....but...

I can't see edit parameter option anywhere to be honest, can't find it 

[bcdobbs]

I'm not sure if you can get back to the GUI but if you click on the parameter table it creates:

You can then edit the table definition in the expression bar:

Syntax is GENERATESERIES(Start, End, Increment)

[VijayP]

@BarSi1986 
you can do that , Just go to column generated from the Whatif window and you will see the GenerateSeries Function

in that change the increment (final parameter) to what ever value you want!

[BarSi1986]

ok, it works.....almost 🙂 

now if i type, for example 1592 --> it automatically changes to 1590 (incrementation is now by 1...)

so the DAX looks like that: 

param value  = GENERATESERIES(0, 5000, 1)

[amitchandak]

@BarSi1986 , it should have created a table using generateseries. Go and modify that and try

[BarSi1986]

ok, it works.....almost 🙂 

now if i type, for example 1592 --> it automatically changes to 1590 (incrementation is now by 1...)

so the DAX looks like that: 

param value  = GENERATESERIES(0, 5000, 1)

[amitchandak · Accepted solution]

@BarSi1986 , That is because what if parameter sampling.

Better you create your own table using series using generateseries(1,5000,1) and use that