cancel
Showing results for
Did you mean:
Helper I

## Flag to show current and previous FY

Hi,

I have a financial year column which outputs the financial year of the record we store (e.g FY21/22)

The financial year runs from 1st September to 31st August.

What I'd like, if possible, is to have a flag that outputs "current fy" and "previous fy" based on the date range above.

So, as of today, FY20/21 will show "previous fy" and FY21/22 will show "current fy".

And when we move to 1st September 2022, that will show as "current fy" and FY21/22 will change to show "previous fy" and FY20/21 will then show as "blank".

1 ACCEPTED SOLUTION
Frequent Visitor

We need 2 date marks: start_of_currentFY and start_of_previousFY to define flag

measure start_of_currentFY =

if (MONTH(TODAY()) in {9,10,11,12}, DATE(YEAR(TODAY()),9,1),DATE(YEAR(TODAY())-1,9,1))
measure start_of_previousFY
if (MONTH(TODAY()) in {9,10,11,12}, DATE(YEAR(TODAY()-1),9,1),DATE(YEAR(TODAY())-2,9,1))

then we make comparasion to define flag in data table:

column Flag = if ( Date >= start_of_currentFY, "CurrentFY",if ( Date >= start_of_previousFY,"Previous FY", blank()))
2 REPLIES 2
Frequent Visitor

We need 2 date marks: start_of_currentFY and start_of_previousFY to define flag

measure start_of_currentFY =

if (MONTH(TODAY()) in {9,10,11,12}, DATE(YEAR(TODAY()),9,1),DATE(YEAR(TODAY())-1,9,1))
measure start_of_previousFY
if (MONTH(TODAY()) in {9,10,11,12}, DATE(YEAR(TODAY()-1),9,1),DATE(YEAR(TODAY())-2,9,1))

then we make comparasion to define flag in data table:

column Flag = if ( Date >= start_of_currentFY, "CurrentFY",if ( Date >= start_of_previousFY,"Previous FY", blank()))
Helper I

Thank you so much for your help, I really do appreciate it.

Announcements

#### Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

#### European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

#### Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors