Year over Year Comparison

zflory

Interesting dataset. You still need one table, no point in have two separate tables with the same field and data types.

I recommend to add a Year field to each table. 2016 table gets 2016 value for every row and 2017 table get 2017 value for every row.

You can do this in Power Query

Under the Add Column tab, click Custom Column and add  "=2016"    this will add column with 2016 value for every row in your 2016 table. One the home tab, under transform please convert  the new Year column to a whole number

Repeat the same operation for 2017 year.

Create a new blank query and enter the following code = Table.Combine({#"2017", #"2016"}). This will create a new table which is a union of 2016 and 2017. Click Close and Apply to move your changes into the model.

Now, you can use your newly created field Year as slicer and write DAX to get that YoY metric.
Something like this should work

YoY Value = 
VAR Value2016 = CALCULATE(SUM(Combined[One ]), Combined[Year] = 2016)
VAR Value2017 = CALCULATE(SUM(Combined[One ]), Combined[Year] = 2017)
RETURN
Value2017 - Value2016  
	

I would recommend to capture dates in your system for your trnasactions too. Not just years.

N -