cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Frequent Visitor

## Month-to-Month Change With Multiple Values

Hi all - i am trying to display month-to-month percentage for Multiple values (A, B, C) stored in the same colunm.

 Month IdAttribute Attribute Value June 1 A 200 June 2 B 100 June 3 C 200 July 1 A 50 July 2 B 25 July 3 C 500 August 1 A 30 August 2 B 250 August 3 C 115

Or

 A B C June 200 100 200 July 50 25 500 August 30 250 115

The value of B obtained in July is the result of the evolution of the value of A in June.
I would like to perform a Month/Month percentage calculation of B versus A and C versus B.
Simply: B (July)/A(June) = __% or C (July)/B(June) = __%

Do you have any tips (DAX measures) that could help me with this calculation?

2 ACCEPTED SOLUTIONS
Resident Rockstar

Here is one way, .pbix file attached

Frequent Visitor

Hi

you need a common Date table, to use  PREVIOUSMONTH

total =SUM (value)

value_percent =

var a = SELECTEDVAUE (attribute)

return SWITCH (a,

"A", blank(),
"B", total / CALCULATE (total, REMOVEFILTER (attribute), attribute = "A", PREVIOUSMONTH (Date)),
"C", total / CALCULATE (total, REMOVEFILTER (attribute), attribute = "B", PREVIOUSMONTH (Date)),

blank() )

Creata Matrix with month and attribute like you show, and add "value_percent' as value

3 REPLIES 3
Frequent Visitor

Hi

you need a common Date table, to use  PREVIOUSMONTH

total =SUM (value)

value_percent =

var a = SELECTEDVAUE (attribute)

return SWITCH (a,

"A", blank(),
"B", total / CALCULATE (total, REMOVEFILTER (attribute), attribute = "A", PREVIOUSMONTH (Date)),
"C", total / CALCULATE (total, REMOVEFILTER (attribute), attribute = "B", PREVIOUSMONTH (Date)),

blank() )

Creata Matrix with month and attribute like you show, and add "value_percent' as value

Frequent Visitor

However my main difficulty is that I would like to have a measure that works no matter which attribute is chosen, not only for B/A.
That is to say, a measure capable of producing the following result:

 A B C July B/A C/B
Resident Rockstar

Here is one way, .pbix file attached

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors