Need help with simple Calculation formula

[Anonymous]

Hi all, i am very new to Power BI and having a difficult time solving simple formula.

I have three tables I want to use.  (Some columns are blurred out for privacy reasons)

1) FG receipt table

This is the raw data. (Among 8 columns, I only need to use 3 columns. Avail/ ReqD col., Product col., Rec/ReqQty col.,). Preferrably I do not want to touch this, as this data is stored in webserver and updated monthly

2) Product Price table

This is a reference sheet I've created, which tells you the price of each SKU

3) Summary table

This is the table I want the output to be shown in.

I want to extract goods receipt date (Avail/ ReqD column) sales qty (Rec/ ReqQty column) and SKU (product column) from FG receipt table. Here, I want to show monthly sales amount per brand (and not SKU) by multiplying sales qty (from FG receipt table) by price shown per SKU (from product price table).

 

The problem I'm having is, some brand (say Brand A) has multiple SKUs (ex. F00003437 & F0000338). Is there a way to extract sales amount per brand and not SKU? 

For example, on Summary table first row of Sales Actual column, I want to show total amount of sales for F00003437 and F00003438 for December 2020.

This is my first Power BI project and I've been stuck here for the past few days... Any insight would be helpful. Thank you

[Greg_Deckler]

@Anonymous So in general yes. You would use something like SUMMARIZE or GROUPBY. However, having trouble following, can you post sample data as text and expected output?

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.