If statement related to date

[AMFi]

Hi,

I hope some could help me with my issue. I get one of mine € amount for data only including VAT. I have a quick mesure to deduct the VAT, but since the tax rate has changed, I should get an if-statement that changes that divider after a certain date. How would this be possible to implement?

[ryan_mayu · Accepted solution]

@AMFi 

do you have the tax rate table?

you can try to use DATE function to compare the dates

https://learn.microsoft.com/en-us/dax/date-function-dax?wt.mc_id=DP-MVP-5004616

if this can't solve your problem, pls provide some sample data and expected output