Forum Discussion
Comparing prices based on scale price (different quantities)
amitchandakthanks for your answer. But unfortunately I don´t understand your solution.
I try to make my problem more clear. Maybe it helps.
This is how should look like in the end:
For example:
The price for product B, Revenues 180€, is 30€ if someone buys 6 units. If someone gets for e.g. 15 units, the price is 28€. All over 11 units the price is 28€.
1. Does it make sense to work in the table scale price with range over two columns or is one column for units enough?
Scale price table:
Do you have another idea to solve my problem?
Thanks for your support!
Freiburgc
You can create a measure using lookup. or can try using create a column in table 1 like this
Max price= Maxx(filter(Table2,Table1[product]='Item'[product] && Table1[posting date]>='table2'[posting date]),table2[price ]) Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
amitchandakthanks for your answer. But unfortunately I don´t understand your solution.
I try to make my problem more clear. Maybe it helps.
This is how should look like in the end:
For example:
The price for product B, Revenues 180€, is 30€ if someone buys 6 units. If someone gets for e.g. 15 units, the price is 28€. All over 11 units the price is 28€.
1. Does it make sense to work in the table scale price with range over two columns or is one column for units enough?
Scale price table:
Do you have another idea to solve my problem?
Thanks for your support!
Freiburgc