How to Find the Fiscal Week Number of a Date in Tableau

In this silent video, you’ll learn how to using date functions, such as DATEPART() in Tableau. in order to find the Fiscal Weekly number of a date.

Read the full article here: Using Date Functions with Fiscal Years —


- - - - - - - - - - - - - -


Create a calculation that returns the expected fiscal date part number to use in future calculations. Depending on the date level needed and the use case, the exact formula will differ. In the below examples, the fiscal year start for [Order Date] is set to February.


For a weekly calculation, create 4 calculated fields using formulas similar to the ones described in this Knowledge Base article:
(Note: the -1 should be replaced with the correct number to shift January to the first month of the fiscal year.)


In the example described in this video, we're converting the newly created calculated field to a Dimension so that we can compare it with the other date field in the view.


- - - - - - - - - - - - - -


Subscribe to the Tableau YouTube channel here:


Free Trial of Tableau: link:

tableau,tutorial,how to,data visualization,gss,fiscal week,fiscal date,