Forum Discussion

lennyt99's avatar
lennyt99
Helper I
3 years ago

Help please asap!

My fiscal Year data is wrong for FY 20 & FY 21... why is this happening but it's correct for FY 22,23,& 24?? This is my Volume LY Formula   Volume LY = CALCULATE( SUM('Opportunity Tracke...
amitchandak's avatar
amitchandak
Super User
3 years ago

lennyt99 , seem like related to leap year, Try like

Volume LY =
CALCULATE(
SUM('Opportunity Tracker 2.0'[Annual Volume LBS]),
SAMEPERIODLASTYEAR('Fiscal Year Conversion'[Calendar Date]))

lennyt99's avatar
lennyt99
Helper I
3 years ago

I've tried that also, however yields the same result. What if a filter is used only for the fiscal year?

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    lennyt99 ,Only for year level

    Rank on FY start Date or Fy year number (sortable)

    Year Rank = RANKX(all('Date'),'Date'[FY Year Start date],,ASC,Dense)

     

    Measure
    This Year = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year Rank]=max('Date'[Year Rank])))
    Last Year = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year Rank]=max('Date'[Year Rank])-1))