Calculating measure value for current year and month from one table to another table

[Anonymous]

Hi Community,

I was trying to calculate last year month sales based on current year and month sales.

I have a Table 1 contains data from 2018-01-01 to 2019-04-31 with sales  and

I have Table 2  contians data for 2019-04-31 with sales

Now my requirement is that I want to filter the table 1  for 2018-04-31 based on table 2 data.

Any help on this

[v-lili6-msft]

hi, @Anonymous 

You could SAMEPERIODLASTYEAR Function to add a measure:

https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

Create a date table, then create a relationship with table1 and table2 as a bridge.

Best regards,

Lin