Forum Discussion
Helper IIwhatif analysis
Community ChampionHmm, might be version dependent. Try going to File | Options and settings | Options and then go to Preview Features and see if it shows up there and if it does, confirm that the box is checked.
Oh, also, is this a Direct Query report? I don't believe that functionality is available in a Direct Query report because you can't mix "live" and "imported" data yet.
Helper IIYes its a direct query, but if i need to do the whatif anaysis with direct query then how i can do it.
- Greg_Deckler
You would add the desired What If parameter table to your model in your source.
- prashant_ora
how to add whatif paramter in data source, can u please tell me?
- Greg_Deckler
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.