Forum Discussion
New calculated column
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
2 Replies
could you help provide some sample data to help those who might help you?
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
