Forum Discussion

MarkCBB's avatar
MarkCBB
Helper V
9 years ago
Solved

Last Year This/Same Week

Hello there,   I created the follow DAX Measure to calculate This Year This Week, I am sure there is a better way to do this, but this does work: TYTW Units = CALCULATE([Total Units],FILTER('CALEN...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    How is [Week Year ID] stored?  Could you build last years [Week Year ID] by making use of the same one you used in your TWTY measure?

    For Example if [Week Year ID] is YYYYWW you could build the string using a combination of LEFT and RIGHT to get the Year and Week components, then decrement the YYYY by one and build a new filter string from there.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

How is [Week Year ID] stored?  Could you build last years [Week Year ID] by making use of the same one you used in your TWTY measure?

For Example if [Week Year ID] is YYYYWW you could build the string using a combination of LEFT and RIGHT to get the Year and Week components, then decrement the YYYY by one and build a new filter string from there.

MarkCBB's avatar
MarkCBB
Helper V
9 years ago

Hello Anonymous

 

Your approach works well, I changed the measure seems to works well:

PYTW Units = CALCULATE([Total Units],FILTER(ALL('CALENDAR'),'CALENDAR'[Week Year ID]=MAXX('CALENDAR','CALENDAR'[Week Year ID]-100)))

-100 to get the same week previous week

 

Thank you