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

New Member

## how to calculate the variation rate in a table

Hello everyone,

I have a question about calculating the variance of facts from different columns.
An example, I want to calculate the variation percentage between january and february in each branch, and show the result in a third column.
I attach n example to illustrate my doubt.

Kind regards

1 ACCEPTED SOLUTION
Helper I

In your case it will be something like:

`test2 = (CALCULATE(SUM('Fact - Journals'[ACCOUNTED_AMOUNT]);'Dim - Period'[Fiscal Month] = "201709") - (CALCULATE(SUM('Fact - Journals'[ACCOUNTED_AMOUNT]);'Dim - Period'[Fiscal Month] = "201702")) ) /  (CALCULATE(SUM('Fact - Journals'[ACCOUNTED_AMOUNT]);'Dim - Period'[Fiscal Month] = "201702")) * 100`

Helper I

In your case it will be something like:

`test2 = (CALCULATE(SUM('Fact - Journals'[ACCOUNTED_AMOUNT]);'Dim - Period'[Fiscal Month] = "201709") - (CALCULATE(SUM('Fact - Journals'[ACCOUNTED_AMOUNT]);'Dim - Period'[Fiscal Month] = "201702")) ) /  (CALCULATE(SUM('Fact - Journals'[ACCOUNTED_AMOUNT]);'Dim - Period'[Fiscal Month] = "201702")) * 100`

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.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors