cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Create new column with ratio based on values in one column and filter on other column

Hi there,

I am trying to create a new column "Ratio" which calculates the ratio of the quantities sold (#) in the product groups (A/B) in a specific calendar week: # product A/ (# product A + # product B)

 Product group Calendar Week Quantities sold (#) Ratio A 1 12 Ratio (week 1)= 12/(12+8) B 1 8 Ratio (week 1)= 12/(12+8) A 2 14 Ratio (week 2)= 14/(14+7) B 2 7 Ratio (week 2)= 14/(14+7)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage

@Arual123  try this in a calculated column

and this in a visual

Highlighted
Solution Sage

@Arual123  try this in a calculated column

and this in a visual

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors