New column/measure from 2 different tables in the reports view

[apoje]

Hi, 

I am relatively new to the PowerBI and I cannot find a solution for the below problem.

I have 2 data tables. One is the stock in the warehouse which has 120 rows. And another is sales data, which containes 10000+ lines since each purchase is a line. 

I want to combine the two in the reports page to calculate between sales of last 30 days and current stock. Basically to see if the product is under the 30day stock. 

I managed to create a date filter and combine the relationships between the 2 tables based on the product code. but I cannot make the calculation between them... 

I get the data in the reports view but I cannot create the claculation between them. In the Report view I see the quantity and sales in the same table I just cannot calculate between them...

Does anyone know how to solve this? 

Regards,

Andraz 

[v-yuta-msft]

@apoje ,

Could you clarify more details about your requirement and post your sample data?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.