cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
Resident Rockstar
Resident Rockstar

@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
Resident Rockstar
Resident Rockstar

@Jean_LucGUE 

 

Here is one way, .pbix file attached

Vera_33_0-1659878253340.png

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors