Sameperiodlastyear with only year and week per product

[Anonymous]

Good morning  everyone,

With only 2 "date-like" columns, YEAR (i.e: 2018) and WEEK (i.e.: 34), what formula can I use to get sales from year ago same week for each product ? 

YEAR    WEEK     SALES Product 

2018     34          1000     A 

2017     34          980       A

I need 

YEAR    WEEK     SALES      SALES YAG   Product 

2018     34          1000       980                   A

Any idea ? 

Many thanks, 

[Icey]

Hi @Anonymous ,

Is this problem sloved?
 
If it is sloved, could you kindly accept it as a solution to close this case?
 
If not, please let me know.
 

 
Best Regards

Icey

[Icey · Accepted solution]

Hi @Anonymous ,

You can create your measure like so:

SALES YAG =
VAR last_year =
    SUM ( 'Table'[YEAR] ) - 1
RETURN
    CALCULATE (
        SUM ( 'Table'[SALES] ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[Product], 'Table'[WEEK] ),
            'Table'[YEAR] = last_year
        )
    )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.