DAX This Year against LY SCD

[bestevez]

Hi,

I need to know how much I bought de PrdID 1 in 2018 where PrdID 1 in 2018 es 2 like the column PrdIDLY show.

ProductId	DAteKey	PurchaseDate	Amount	Index	PrdID	PrdIDLY
1	20190405	05/04/2019	3	1	1	2
1	20190405	05/04/2019	2	1	1	2
1	20190407	07/04/2019	2	1	1	2
1	20190407	07/04/2019	1	1	1	2
2	20180405	05/04/2018	5	2	2	3
2	20180405	05/04/2018	5	2	2	3

Regards

[az38 · Accepted solution]

Hi @bestevez 

If I understand you correct try a measure

Measure = CALCULATE(
    SUM('Table'[Amount]);
    FILTER(ALL('Table');'Table'[PrdID]=SELECTEDVALUE('Table'[PrdIDLY]) && YEAR('Table'[PurchaseDate])=YEAR(SELECTEDVALUE('Table'[PurchaseDate]))-1)
)

do not hesitate to give a kudo to useful posts and mark solutions as solution