Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

year to date in query editor

Hello   Is it possible make a year to date column in query editor? I need the year to date column for a conditional column where would do something like that: if customer turnover is bigger than...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I've created the following columns in each of the calendar table and it all starts with either July or January. But, I'd like to have to start with April of each year and ends with the March of the following year. How it's possible to create a calendar for the financial year April to March 2018? 

 

If you do have any advance editor script, please share it up with me. Somehow, I've managed to find out a couple of things in fact, that didn't satisfy my hunger. It is because whenever I'd try to figure out the visualization the fiscal month numbers and fiscal quarters are not matching up. I've search out a dozens of websites and still they're not able to provide me with a proper solution. Can you please, help me up to figure it out? 

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    8 years ago

    I'm not sure if I got your request right, so please share sample data of:

    1) Your source data and

    2) The desired result.

    Thanks.

    • Newbie1's avatar
      Newbie1
      Frequent Visitor
      8 years ago

      If its just generating fiscal calendar, then, open query editor, on the left hand side go to new source, blank query and write below formula

      = List.Dates(#date(2017,4,1) , 365 ,#duration(1,0,0,0))

       

      I hope it helps