How I can find the lease area that is falls in financial year Apl 2022 - Mar 2023, but its contract is start date and contract end date is any random date.

Question

for example, Contract start date 14-02-2014 Contract End Date 13-02-2031 that means area consumption is consider in financial year 2022-2023

Don Wise · Answer

You'll need to look at Date Scaffold methods to achieve: https://community.tableau.com/s/global-search/%40uri#q=date%20scaffold&t=All Many examples at that link.

Best, Don

(Please, don't forget to click Select as Best or Upvote !)

Tableau Desktop & Web Authoring