Forum Discussion
lennyt99
Helper I
Helper IMy calculations not displaying, only total
I've written 3 different ways to calculate last year volume, and the total is correct, however the values are not dipslaying on my matrix??? What's going on here?
Thank you
My bad:@lennyt99 Sorry, forgot the ALL:
Volume LY = VAR __Date = MAX('Fiscal Calendar'[Daily Date]) VAR __LYDate = EOMONTH(__Date,-12) VAR __LYEndDate = DATE(YEAR(__LYDate),MONTH(__LYDate),DAY(__Date)) VAR __LYDateStart = EOMONTH(__LYDate,-12) VAR __LYStartDate = DATE(YEAR(__LYDateStart),MONTH(__LYDateStart),DAY(__Date)) RETURN SUMX(FILTER(ALL('Opportunity Tracker 2.0'),[Date]>=__LYStartDate && [Date]<=__LYEndDate),[Annual Volume LBS])
1 Reply
- Greg_Deckler
Community Champion
My bad:@lennyt99 Sorry, forgot the ALL:
Volume LY = VAR __Date = MAX('Fiscal Calendar'[Daily Date]) VAR __LYDate = EOMONTH(__Date,-12) VAR __LYEndDate = DATE(YEAR(__LYDate),MONTH(__LYDate),DAY(__Date)) VAR __LYDateStart = EOMONTH(__LYDate,-12) VAR __LYStartDate = DATE(YEAR(__LYDateStart),MONTH(__LYDateStart),DAY(__Date)) RETURN SUMX(FILTER(ALL('Opportunity Tracker 2.0'),[Date]>=__LYStartDate && [Date]<=__LYEndDate),[Annual Volume LBS])