Forum Discussion

lennyt99's avatar
lennyt99
Helper I
3 years ago
Solved

Help!

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

lennyt99's avatar
lennyt99
Helper I
3 years ago

When I do it just returns the anual volume BA_Pete 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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