To calculate different taxes by year and product

[Anonymous]

Dear community,

I need to calculate a tax column, which varies by year, and it is applied to a product.

Product	Year	Price
A	2020	20
B	2021	21
A	2021	22
A	2022	23

 The tax should be applied just to product A, and if the year is <2022, it will be 7% of the price; otherwise will be 4% of the price.

I have tried a calculated column:

Tax= if(Table[Year]<2022,filter(Table,Table[Product]=A)*0.07,filter(Table,Table[Product]=21)*0.04). Unfortunately it didn't work well.

Any tips on this?

Thanks in advance.

Cheers

[camargos88 · Accepted solution]

@Anonymous ,

You can create this new column using Power Query:

if [Product] = "A" then
   if [Year] < 2022 then [Price] * 0.07 else [Price] * 0.04
else null

Or this for a calculated column:

Tax_DAX = IF('Table'[Product] = "A", IF('Table'[Year] < 2022, 'Table'[Price] * 0.07, 'Table'[Price] * 0.04), BLANK())