Option 1 

1. Connect to Sample - Superstore data.
2.  Create a new calculated field as follows:
     Name : Fiscal Year(Option 1)
     Calculation : IF MONTH([Order Date]) = 4
                          AND DAY([Order Date]) <= 15
                          THEN DATE(DATEADD ('year', -1, [Order Date]))
                          ELSE [Order Date]
                          END
3. Right-click on Fiscal Year(Option 1) then select Fiscal Year Start > April.
4. Drag Order Date to Rows then right-click and select Order Date > Discrete.
5. Drag Fiscal Year(Option 1) to Rows and drill down to MONTH.

Confirm that 4/16/2021 to 4/15/2022 is FY2022.

Option 2 

1. Connect to Sample - Superstore data.
2.  Create a new calculated field as follows:
     Name : Fiscal Year(Option 2)
     Calculation : IF MONTH([Order Date]) = 4
                          AND DAY([Order Date]) <= 15
                          THEN DATE(DATEADD('year', -2, [Order Date]))
                          ELSE DATE(DATEADD('year', -1, [Order Date]))
                          END
3. Right-click on Fiscal Year(Option 2) and select Fiscal Year Start > April.
4. Drag Order Date to Rows then right-click and select Order Date  > Discrete.
5. Drag Fiscal Year(Option 1) to Rows and drill down to MONTH.

Confirm that 4/16/2021 to 4/15/2022 is FY2021.