cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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

1 ACCEPTED SOLUTION
Super User

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

Proud to be a Super User!

Learn about the Star Schema, it will solve many issues in Power BI!

Super User

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

Proud to be a Super User!

Learn about the Star Schema, it will solve many issues in Power BI!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.