Forum Discussion
Calculating What-If Using Category as Number
Hello everyone!
I am currently running into a bit of a two-pronged problem with some What-If calculations. I have a snapshot of my intended outcome below:
What I am trying to calculate is the amount of visits for each new visit type (columns H,J,L,N,P,R). I have the steps outlined, and what they should perform in H5 through H7.
The second problem i am having is, how do I create this in one neat matrix? I am a bit lost on where to begin with this. I do have a What-If standalone table that looks like this:
| Visit Type | Number |
| Type A | 100 |
| Type A | 50 |
| Type A | 25 |
| Type B | 80 |
| Type B | 60 |
| Type B | 40 |
And is connected to the main visit table with a Many:Many both ways based on Visit Type.
Any help is greatly appreciated!
Your intended outcome is not achievable with Power BI. Either keep using Excel or modify your requirements.
1 Reply
- lbendlinSuper User
Your intended outcome is not achievable with Power BI. Either keep using Excel or modify your requirements.