Forum Discussion

BoostNest's avatar
BoostNest
Frequent Visitor
9 years ago

Month & Year order

Hi would appreciate some help. We are currently limited to usingt he app only not desktop so some of the other solutions don't/can't work for us.   We are trying to create a sales report that show ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Oh, the data is fed from Xero, I see.

So I would recommend that you use YYYYMM format for Year-Month

This way it will order it ascending . Maybe YYYY-MM will also work for better presentation

Michael

BoostNest's avatar
BoostNest
Frequent Visitor
9 years ago

Thanks again Michael for your reply, we are running OS X so am trying to get a solution without having to use windows VM.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Yes, I understand you don't want to use Desktop.

    So I propose that you create a new column in your CalendarTable

    =FORMAT(CalendarTable[Date],"YYYYMM") and use this column in your report instead of the current one. 

    So you will get the months ordered properly: 201611, 201612, 201701 etc.

    All this you can do in the online Service

     

    • BoostNest's avatar
      BoostNest
      Frequent Visitor
      9 years ago

      Thanks Michael, looks like an excel formula. I can't see anywhere in the Online app that allows you to enter those, simply edit and apply filters to the Xero dataset, which itself doesn't seem to be able to be edited.

       

      I've had a bit of a google and it appears that you either need to edit in excel with the updates (windows) or use desktop. Is this what you mean?