Retrieve Previous FiscalMonth from the table that has data in YYYYMM

I want to retrieve previous fiscal month from my data.

I can using a filter tool to retrieve the need month, but don't want to do it manually by changing the Fiscal month every time, instead want it automated so every time i run my workflow it needs to retrieve only previous month data.

Data.xlsx

Workflow

Accepted answers

All comments

Luke_C

Hi @dcsramya

You could use a filter like this. Essentially, subtract one month from today's date and format it to the YYYYMM format.

tostring([FIS_MTH_ID]) = datetimeformat(datetimeadd(datetimetoday(),-1,'month'),'%Y%m')

dcsramya

Thanks Luke

My fiscal Period in the table is from Oct23 to Sep24 and my previous period would be 202406 and not 202403. Since we are using Date time today it's fetching 202403 period.

Luke_C

Hi @dcsramya

Got it. I'm not following how 202406 is the previous period. Previous compared to what?

Bren_Spill2

Hi @dcsramya - if you change -1 to +2 in @Luke_C's logic it will work.

@Luke_C - March is the 6th month of the 2024 fiscal year so we get 202406

dcsramya

+2 worked

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703