Calculate Growth

Hi sban,

Please create a new table by clicking "New Table" under Modeling on Home page, type the following formula. Please check more details of SUMMARIZE function here.

Table =
SUMMARIZE (
    'Fact',
    'Fact'[Market],
    'Fact'[Product],
    'Fact'[Account],
    'Fact'[Year],
    "sum of amount", SUM ( 'Fact'[Amount] )
)

Then create a calculated column to get the previous year's sum of amount based on product, market and account.

Previous year sum amount =
LOOKUPVALUE (
    'Table'[sum of amount],
    'Table'[Market], 'Table'[Market],
    'Table'[Product], 'Table'[Product],
    'Table'[Account], 'Table'[Account],
    'Table'[Year], 'Table'[Year] - 1
)

Finally, create a difference of amount total between this year and previous year(2017-2017, 2017-2018,2018-2019).

Difference = 'Table'[sum of amount]-'Table'[Previous year sum amount]

Please download the attachment file for detailed information.

Best Regards,
Angelia