Manual Calculation Tied To a Specific Location POWER BI

Ryan Crary 0

Hello!

I'm trying to calculate a function in POWER BI that is simple to do in excel.

Example:

I have 7 locations for my business and my annual goal is a specific benchmarked month times a percentage.

Location 1 = 778 * 0.07

Location 2 = 24 * 0.09

and so forth.

Each location has a different percentage or weight to help adjust for the total.

QUESTION:

How can I pull the locations out of my tables and assign this manual calculations in Power BI?

Simon Harrison 10 Reputation points

2023-06-21T14:38:18.02+00:00

Just to be clear,

The Percentages such as the 0.07 for Location 1 are held in a Locations table?

Assuming you have a fact table such as a Sales table which also has the Location 1 reference

You can use the relationship between these 2 tables to use the percentages for a subsequent calculation

Here is an example

https://www.selectdistinct.co.uk/2023/03/15/power-bi-related-function/

Happy to help, if you need any help with it let me know

Simon
Ryan Crary 0 Reputation points

2023-06-21T15:24:41.25+00:00

Unfortunately those percentages are manual calculations :(
So I'm trying to see if I can add that manual calculation to each branch that is located in the tables.

So the locations are in one table and then I want to add the manual calculation for each location.

Does that help clarify?

(Sorry I'm still trying to wrap my head around how to accomplish this and how to phrase it correctly).
Simon Harrison 10 Reputation points

2023-06-21T15:46:17.0933333+00:00

Maybe you could share a simple spreadsheet example?
Simon Harrison 10 Reputation points

2023-06-21T15:47:12.3833333+00:00

No problem about trying to phrase it, its not always explain to explain what you are looking to do
Ryan Crary 0 Reputation points

2023-06-21T18:16:19.89+00:00

I hope this helps make sense. Example of Weighting by Location.txt
Ryan Crary 0 Reputation points

2023-06-21T18:16:30.84+00:00

I hope this helps make sense. Example of Weighting by Location.txt
Simon Harrison 10 Reputation points

2023-06-22T11:05:31.13+00:00

So, I dropped the data you sent into Excel

The Weight percentage, you say its a manual calculation, Could you explain that part a little more please

i.e. the 0.07 against Location 1, how do you calculate it

thanks

S
Ryan Crary 0 Reputation points

2023-06-23T12:41:32.3233333+00:00

So the weight calculation is just Column C multiplied by Column B.

Location 1 = .07*504000

Location 3 = .09 * 90234

and so on.... it would be easier if the values in column C were the same.. but having them weighted differently based on location goals makes this problem a bit more complicated.

Share via

Manual Calculation Tied To a Specific Location POWER BI