none
finding number of months left in year RRS feed

  • Question

  • hi all,

     how can i find number of months left in fiscal year. i'm calculating ytd total for months oct-april in FY oct 14-sep 2015.here remainaing months are 5(may-sep).how can i find the number of months reamiining whose sales is not included i.e 5

    thanx in advacne..


    lucky

    Monday, July 3, 2017 12:00 PM

Answers

  • Hi Lucky,

    Date.Month([Date])- FMFY +1+ (if Date.Month([Date]) < FMFY then 12 else 0)
    where FMFY is the number of month when FY start ( april -> 4, september -> 9 etc)

    • Marked as answer by LuckyLucky12 Tuesday, July 4, 2017 6:00 AM
    Monday, July 3, 2017 12:32 PM

All replies

  • Hi Lucky,

    Date.Month([Date])- FMFY +1+ (if Date.Month([Date]) < FMFY then 12 else 0)
    where FMFY is the number of month when FY start ( april -> 4, september -> 9 etc)

    • Marked as answer by LuckyLucky12 Tuesday, July 4, 2017 6:00 AM
    Monday, July 3, 2017 12:32 PM
  • thanx for the reply Bill Szysz..it worked for me..

    lucky

    Tuesday, July 4, 2017 6:01 AM