calculate sales for current year 2020-2021

[Anonymous]

Sample data :

Mode    date          Unit  Price

Online  1/1/2020    40     2812

Online   1/9/2020   120    4125

Store    1/4/2021    30     1231

Store     1/3/2021   20     6721

i need a measure which sums up unit * price only for 2020 and 2021

Current yr 2020-01= unit * price for only 2020 and 2021 year

But i want to include 2020 and 2021.

[ryan_mayu · Accepted solution]

@Anonymous 

What's your expected output?

is this what you want?

Measure = SUMX(FILTER('Table (2)',year('Table (2)'[date]) in {2020,2021}),'Table (2)'[Unit]*'Table (2)'[Price])