Transaction type and volume based costing

[Mr_Asrar]

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.

[amitchandak]

@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.

[Mr_Asrar]

@amitchandak @pranit828 

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.

[pranit828]

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?

[pranit828]

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]))