Forum Discussion
If statement related to date
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?
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
1 Reply
ryan_mayuSuper User
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