Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Getting Same Quantity for This Year and Last Year Time Frame

Hello,   I have the following where i am tracking Quantity on a week by week basis over multiple years.   I have my Calendar table (my own Excel file as my week numbers are slightly different tha...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

    QTY LY =
VAR _year = MAX('Calendar'[Year]) -1
VAR _Week = MAX('Calendar'[WeekNumber])
RETURN

CALCULATE( 
SUM('Merge_Table'[Quantity]),
FILTER(
ALL('Calendar'),
'Calendar'[Year] =  _year &&
'Calendar'[WeekNumber]= _Week
)
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Ahmedx 

 

Would a ISINSCOPE option work here?

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

it depends on your matrix, if you have it as a hierarchy, weeks and month and year, then yes such a function will help

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I have a hierarchy, however I use a Year_Week as that is what the client wants to see. They want to drill down from year to quarter (or skip quarter) to month to Year_Week that would fall within the month. Can this still be down?