cancel
Showing results for
Did you mean:
Helper III

To calculate different taxes by year and product

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?

Cheers
1 ACCEPTED SOLUTION
Super User III

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())``

Proud to be a Super User!

Super User III

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())``

Proud to be a Super User!

Announcements

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.