Calculated columns real problem

[ybatistamayo]

Hello friends

I have the following problem to solve:

My data set has two tables, the first transactional "Cost" and the second one of "Taxes" which changes the Taxes every year.

I want to add two calculated columns to the "Cost" table:

COLUMN 1 = tax1 (Amount)

COLUMN 2 = PRICE * TAX2 (Porc) / 100

The challenge is the calculations in the "cost" table above 8/20/2019 are calculated taking into account the 2018 values ​​of the "Taxes" table.

(marked in red).

The same for what is marked in Blue.

This is required to keep the history in the database of previous tax calculations as of 8/20/2019.

I leave the calculations with the answer

Here PBIX: https://we.tl/t-sKNn99k0Pc

table cost

tables taxes

[Anonymous]

Use if else to calculate the different tax amounts.  

If date<X then (PRICE * TAX2 (Porc) / 100) 

else if date >=X  then (PRICE * TAX2 (Porc) / 100) 

else "ERR"

You can put as many of these clauses as you need for different tax amounts by date.

@ybatistamayo 

[ybatistamayo]

Sorry, this is not what I need. Thanks