Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Sorry, this is not what I need. Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |