Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.