How to compare current and previous year's result from two different table and list as bar chart?

[rickylee]

Hello,

I have two tables with different columns. I try to list the total price in table 1 (total price 2018) and the total price from table 2(total price 2017) in a bar chart. So people can look at current year's total price and the previous year. I only need to compare monthly i.e. 2018 Jan compares to 2017Jan. I mange to learn "SAMEPERIODLASTYEAR" but no joys because I have two tables rather than one.

Unfortunately, I cannot attach pbix file  but both tasble can be see here:

Date	Assessment	Price	Assessor	Modification date
01/01/2018	A	10
11/01/2018	B	10
21/01/2018	C	10
01/02/2018	A	20
11/02/2018	B	20
21/02/2018	C	20

Date	Assessment	Price
01/01/2017	E	100
11/01/2017	F	100
21/01/2017	G	100

I tried to put both price in the both tables together. Somehow, the total price in 2017 appears when the date is 2018. 

Could someone help? "SAMEPERIODLASTYEAR" won't work becasue I have two tables. By the way, is there a way to attach file / picture?

[v-jiascu-msft · Accepted solution]

Hi @rickylee,

We need a Date table in your scenario. Then these two tables will be connected through the date table. Either of the two measure below will be OK.

Calendar = CALENDARAUTO()

Measure =
CALCULATE ( SUM ( Table2[Price] ), SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) )

Measure =
CALCULATE (
    SUM ( Table1[Price] ) + SUM ( Table2[Price] ),
    SAMEPERIODLASTYEAR ( 'Calendar'[Date] )
)

Best Regards,

Dale

[rickylee]

It works perfectly!

Thank you.

Kind regards,
Ricky