Forum Discussion
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...
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]))
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?