Forum Discussion
Help please asap!
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]))
I've tried that also, however yields the same result. What if a filter is used only for the fiscal year?
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))
Unfortunatly still the same for the period of FY2020. My fiscal calendar start and end date vary.. for exaple one year it starts 9/30, and another it starts 10/2... so perhaps -1 year that's why it's off? How do I do it by fiscal year?
