Forum Discussion
Making a measure date dependent
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 calculati...
amitchandak
Super User
Super UserSeanLooby , 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