Help!

[lennyt99]

My last year volume is not returning the correct volume (Correct volume is the "annual volume LBS"), and this is the dax for LY:

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 of Request Rec'd from Sales]>=__LYStartDate && [Date of Request Rec'd from Sales]<=__LYEndDate),[Annual Volume LBS])

any ideas why this is happening? 

@Greg_Deckler 

[BA_Pete]

Hi @lennyt99 ,

Create yourself a calendar table and relate it to your fact table on Calendar[Date] ONE : MANY FactTable[Date], then use the following measure for prior year:

_Volume LY =
CALCULATE(
    [Annual Volume LBS],
    SAMEPERIODLASTYEAR(Calendar[Date])
)

Pete

[lennyt99]

When I do it just returns the anual volume @BA_Pete 

[v-cgao-msft · Accepted solution]

Hi @lennyt99 ,

Not sure , please try:

Volume LY = 
VAR _fy = MAX('Fiscal Calendar'[FY])
VAR _ly = CALCULATE(MAX('Fiscal Calendar'[FY]),'Fiscal Calendar'[FY]<_fy)
VAR _result = CALCULATE([Annual Volume LBS],'Fiscal Calendar'[FY]=_ly)
RETURN
_result

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data