topic Re: Making a measure date dependent in DAX Commands and Tips

Making a measure date dependent

SeanLooby — Fri, 18 Dec 2020 09:38:05 GMT

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?

Re: Making a measure date dependent

amitchandak — Fri, 18 Dec 2020 10:29:33 GMT

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