cancel
Showing results for
Did you mean:
Regular 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
Super User

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

Regular Visitor

Hello @Vera_33 , thank you very much for your answer.
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
Super User

Here is one way, .pbix file attached

Announcements

#### CollabDays Lisbon - 26 November 2022

Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.

#### Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

#### European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

#### Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors