2 of 2 people found this helpful
Hi Rohan! The reason you're running into this is that currently, Tableau formulas ignore fiscal years. It's annoying, but that's how it is! So 9/20 truncates yearly to 1/1 instead of 7/1, and thus you get FY 2016 when you show it as a fiscal-yearly value. You don't run into this with the quarter because it comes out to the same value regardless of whether Tableau would ignore fiscal years or not.
To get around this, you can use DATE() to manually build the date as July 1 of your year. Maybe something like this:
DATE(STR(YEAR([Date])) + '-07-01')
Let me know if that works!
Btw this worked but I still needed to use that in conjunction with an IIF statement checking if MONTH([date]) >=7 or not.