Reply
ExcelMonke
Super User
Super User
Partially syndicated - Outbound

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:

ExcelMonke_1-1701383709174.png

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!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Syndicated - Outbound

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

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)