Forum Discussion
Edit what if param
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
BarSi1986 , That is because what if parameter sampling.
Better you create your own table using series using generateseries(1,5000,1) and use that
6 Replies
BarSi1986 , it should have created a table using generateseries. Go and modify that and try
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)
BarSi1986 , That is because what if parameter sampling.
Better you create your own table using series using generateseries(1,5000,1) and use that
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)
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)
