cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jean_LucGUE
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. 

MonthIdAttributeAttributeValue
June1A200
June2B100
June3C200
July1A50
July2B25
July3C500
August1A30
August2B250
August3C115

 

Or 

 ABC
June200100200
July5025500
August30250115

 

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
Vera_33
Super User
Super User

@Jean_LucGUE 

 

Here is one way, .pbix file attached

Vera_33_0-1659878253340.png

 

View solution in original post

Hoangechip910
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

 

View solution in original post

3 REPLIES 3
Hoangechip910
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

 

Jean_LucGUE
Frequent 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:

 ABC
July B/AC/B
Vera_33
Super User
Super User

@Jean_LucGUE 

 

Here is one way, .pbix file attached

Vera_33_0-1659878253340.png

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors