Calculating What-If Using Category as Number

[ExcelMonke]

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!

[lbendlin · Accepted solution]

Your intended outcome is not achievable with Power BI. Either keep using Excel or modify your requirements.