cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

Power BI Monthly Update - April 2024

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

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors