Hi 
I've got a question how to write a measure in DAX that shows me the sum of the Discount Amount (let's say USD) a certain customer has received within a certain period. See below the expected output.
There are 3 tables: Customers, Orders and Discounts:
The expected PowerPivot table output is as follows:
For example: Customer Levis in period 2019 has received 6.25 USD discount, calculated as Turnover (40+85 = 125) multipled by Percentage 5% = 6.25.
Please note, that for determining the correct Percentage, there is a Period range (Period From/To) in the lookup table, which makes it quite difficult to look it up.
Do you have any advice how to write this DAX measure?
Regards, Janosh
I've got a question how to write a measure in DAX that shows me the sum of the Discount Amount (let's say USD) a certain customer has received within a certain period. See below the expected output.
There are 3 tables: Customers, Orders and Discounts:
The expected PowerPivot table output is as follows:
For example: Customer Levis in period 2019 has received 6.25 USD discount, calculated as Turnover (40+85 = 125) multipled by Percentage 5% = 6.25.
Please note, that for determining the correct Percentage, there is a Period range (Period From/To) in the lookup table, which makes it quite difficult to look it up.
Do you have any advice how to write this DAX measure?
Regards, Janosh
