Forum Discussion

Lizzieleman's avatar
Lizzieleman
Frequent Visitor
2 years ago
Solved

M code help needed for Fiscal year column in format 23-24 not just 2023

Hi there, I had some help me get to this formula   I've made a date table in power query and I'm looking to add a fiscal year column in the format 2023-24   if (Date.Month([Date])) <=3 , number.T...
Need Help
  • HotChilli's avatar
    HotChilli
    2 years ago

    I think you might be mixing up the DAX syntax with Power Query syntax on this.  To debug, simplify the code, use dummy values until you get it to work, then introduce the more complex code.

    Start with this

    if Date.Month([Date]) <=3 then "a" else "b"

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

I think you might be mixing up the DAX syntax with Power Query syntax on this.  To debug, simplify the code, use dummy values until you get it to work, then introduce the more complex code.

Start with this

if Date.Month([Date]) <=3 then "a" else "b"