Percentage change

[Anonymous]

Hi

I would like to show a measure that would show a measure that would show the % change between the value today in one table against a value today in another table.

Thanks

[Joe_Barry · Accepted solution]

Hi @Anonymous 

If your data model is using a Star Schema and a date table then this can be achieved. The date table date column should have a one to many relationship with "Sales Date" in your two tables.

Create two measures

Sales = SUM(Table1[Amount])

Sales_2 = SUM(Table2[Amount])

Now to work out the % difference

% Difference =

VAR _Diff = [Sales] - [Sales_2]

RETURN

DIVIDE(_Diff, [Sales_2])

If you add the date column from the date table to a visual and then the last measure, then you will see the % difference

Hope this helps

Joe