Forum Discussion

ExcelMonke's avatar
ExcelMonke
Impactful Individual
2 years ago
Solved

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 TypeNumber
Type A

100

Type A50
Type A25
Type B80
Type B60
Type B40

 

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

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