cancel
Showing results for
Search instead 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?

Thanks in adavance.

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

## Helpful resources

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors