How to convert the Transactional year to financial year and month in Tableau and then use it as a filter so when i filter I get given 1 or April i need those data to be filtered
I am trying to use the Finacial month and year as filters in tableau (financial month --- April to March) so i have that field as an inter like (1-12) so i need to convert this into a date format but i am getting it as transaction month (Jan-dec) so i don't get correct data when i filter similarly its financial year 2025 but when i select 2025 i have no data
Hi @Megha Narang
I used that but when I added it in the filter and select to latest date it selected as December and as it is April i dont get the exact data the page goes blank where as the data appears in january 2025 In second my expected output is April 2025
