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

     

1 Reply

  • 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