Making a measure date dependent

[SeanLooby]

Hi,

I calculate fees in Power Bi on a monthly basis. The calculation is (Fee - Rebate) *.23 ....the .23 been the VAT rate.

The VAT rate has now changed to 0.21. However if i change the calculation it will change for the full year and not just the period i want it to change...which is July onwards. How do i do with using Measure in Power Bi?

[amitchandak]

@SeanLooby , You can do that in a formula like

//new column

Switch ( True()

[Date] <date(2020,07,01) , (Fee - Rebate) *.23,

(Fee - Rebate) *.22

)

Or you can create a table and get the rate, refer for a new column : https://www.youtube.com/watch?v=czNHt7UXIe8