cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I

## Formula Question

I am unsure how to do this formula in Power BI.  I have two columns (A&B).  Column A has 10 items, and Column B has 3 items.  I am trying to say this in my formula.  If Column A has Billing and Column B has Accuracy, multply, the percentage in Column C to 70%.  Basically it is a weighted average.

Billing / Accuracy / Jan 2019 * 70%

I created a second table that references the percentages of the weight based on Column A and Column B.

Help!

3 REPLIES 3
Resident Rockstar

You know, it really helps to descibe your data but give some actual data samples. (also, don't post screenshots of tables but copy the values from Excel for example right into the text box here).

Right now, I have absolutely no idea what your question is, what you are trying to achieve and what you expect the result to be? You start with two columns, A and B, then suddenly there is a column C and then you mention a date? What is in the second table?

Proud to be a Super User!

Helper I

You are correct.

Column A is the Category( Cat 1, Cat 2, Cat 3)

Column B is the Sub Category (Sub 1, Sub 2, Sub 3)

Column C is the Value  100%

Column D is the Weighted %

Cat 1/Sub 1 is 34%

Cat 1/Sub 2 is 33%

Cat 1/Sub 3 is 33%

I want to calculate the weighted percentage off of Column A & B using the weight from Column D against the value of Column C.

Resident Rockstar

Please provide some dummy date in an excel sheet with the calculation you want. I still don't understand if you are asking for Column D or something else. Provide table with sample data, then logic, then expected outcome based on the sample data and we will be able to help recreate the logic in Power  BI:)

Proud to be a Super User!