Forum Discussion
Power bi what if analysis
New to DAX
I have a matrix power bi visualization which is like
Jan Feb Mar April
Client1 10 20 30 10
Client2 15 25 65 80
Client3 66 22 54 12
I have created 3 what if parameters slicer table (having value from 1 to 4) for each client
For example If the value of first slicer is 1 and second is 2 and third is 2 then I want
Jan Feb Mar April
Client1 0 20 30 10
Client2 0 0 65 80
Client3 0 0 54 12
that is it should replace the value with zero. I have been able to achieve that for one client using Dateadd function (by adding month)
Measure 1= MIN(Client Name) which gives me Client1 and then I have if(Measure1 ="Client1)) then use measure 2
Measure 2= CALCULATE(SUM('Table'[Value]),DATEADD('Table'[Column],Parameter[Parameter Value],MONTH))
and I have used this measure to display the value, but how to make it work for other two clients as well
2 Replies
- zoloturu
Memorable Member
Please provide us how your table looks like (which is a source for your visuals).
Regards,
Ruslan
- v-frfei-msft
Community Support