Forum Discussion
Transaction type and volume based costing
I am pretty new to the Power BI world and just starting to learn things, i am looking for a cost calculation in the below manner.
Essentially this cost model needs to be applied for each month individually based on the total volume. The table consists of column that can identify the transaction type, along with date column.
Any help or suggestion on how to achieve this would be great.
4 Replies
HI Mr_Asrar
Not much details. Please elaborate.
From what I understand
You need to use
Monthly_cost = CALCULATE(SUM(table[Column to sum]), ALLEXCEPT(MONTH(table[Date]), table[transaction type]))
Mr_Asrar ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
Appreciate your Kudos.amitchandak Anonymous
Alright, sorry about that let me elaborate.
I have transactions in two categories, 1 English and 2 Non-English. I would like to calculate the cost of these transactions monthly. The cost for each non-English transaction is $2 only after 500 transactions but for the first $500 it's $2.4. The cost for English transaction is fixed at $1500 as long as the total count of English transactions is less than 5300.
Hope this gives a bit of clarity, let me know otherwise.Hi Mr_Asrar
How do you have your data laid out in table?
How have you calculated the all the rows(Total transaction) or is it in a column?
When you need month wise break down how do you need the data to be presented?
Is $2 for non-english per transaction?
what about the english transactions if the transaction count is more than 5300?
