Hi All
We give our customers a bonus based on various conditions. Those conditions are different per customer but the same logic.
example:
customer 1: if revenue < 1M€, no bonus. Between 1M and 2M, 5% of sales as bonus, above 2M, 7% of bonus
customer 2: if revenue < 2M€, no bonus. Between 2M and 5M, 7% of sales as bonus, above 5M, 8% of bonus
1% of sales on product A is more than 1 M
2% on the growth (revenue current year - revenue last year) if growth is 10%, 3% if the growth is between 10 and 15%
I am looking at a way to build a DAx formula and why not a data model.
do you have any idea ?
We give our customers a bonus based on various conditions. Those conditions are different per customer but the same logic.
example:
customer 1: if revenue < 1M€, no bonus. Between 1M and 2M, 5% of sales as bonus, above 2M, 7% of bonus
customer 2: if revenue < 2M€, no bonus. Between 2M and 5M, 7% of sales as bonus, above 5M, 8% of bonus
1% of sales on product A is more than 1 M
2% on the growth (revenue current year - revenue last year) if growth is 10%, 3% if the growth is between 10 and 15%
I am looking at a way to build a DAx formula and why not a data model.
do you have any idea ?