Forum Discussion

THEG72's avatar
THEG72
Helper V
6 years ago
Solved

Calendar Fiscal Year Offset M Code for Function

Hi Community,   I have a calendar function and I need to work out how to get the Fiscal Year Offset. I understand I need the current date to extract the current fiscal year but I can't work out the...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi THEG72 

     

    Add this to your code

    FiscalYearOffset = Table.AddColumn( CurrentYearOffset, "FiscalYearOffset", each [Fiscal Year] - List.Max( Table.SelectRows( CurrentQuarterOffset, (a) => a[Date] = CurrentDate )[Fiscal Year] ) , Int64.Type )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

     

parry2k's avatar
parry2k
Super User
6 years ago

THEG72 I would recommend to post this in power query forum

THEG72's avatar
THEG72
Helper V
6 years ago

Hi parry2k thanks for your reply. 

I have done this but no luck yet!

Interested to know if anyone else has a "Dynamic" Fiscal Year Offset in their calendar function?

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    THEG72 Ok then I think I have to roll up my sleeves and look at it. Will try to do it later today and hope someone can help before that.