Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Percentage change

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
Need Help
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    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

     

Joe_Barry's avatar
Joe_Barry
Solution Sage
2 years ago

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