New calculated column

[Matej]

Hello, 

I would like to ask for a help with this specific problem. 

I need a calculated column that would take SUM of Amount from different product categories and divide them by number 30. After that I would like that number to be divided by the "Bed Count" which is a column in a different table. I have tried multiple DAX formulas but nothing seems to do the trick in the way I realy need. Any help would be masively appreciated. 

Matej 

[FreemanZ]

could you help provide some sample data to help those who might help you?

[Matej]

Sorry, I know that the explanation was not clear at all. 

Basically, I have a table like this which contains multiple categories of pruducts we sell to a customer. In this table the price for the products is summed based on the category. 

Next I have another table with customer details containing the amount of beds each customer have available. 

What I am trying to achieve is to write a formula that would calculate daily spending for each category based on per day/per bed. I can do the math in excel in this way (which is very uneficient) = (Total price in the each of the category/30 [AVR amount of days in month])/Bed Count. 

Hope it makes a bit more sense now.

Matej