Forum Discussion
whatif analysis
Yes its a direct query, but if i need to do the whatif anaysis with direct query then how i can do it.
You would add the desired What If parameter table to your model in your source.
how to add whatif paramter in data source, can u please tell me?
I don't know your source but all a What If parameter table is is a list of all possible values that you would like to evaluate something on. So, if I wanted to evaluate something for all possible % values in 10% increments I would have a table like:
0
.1
.2
.3
.4
.5
.6
.7
.8
.9
1
Then you create a slicer based on this table and use SELECTEDVALUE function to get the current value selected.
Hmm, one thought, I don't believe that SELECTEDVALUE is supported in Direct Query:
So, you might have to get creative like just create a measure that is MyValue = MAX('Table'[Column]) for your parameter table.