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 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?
1 Reply
- amitchandak
Super User
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
