Forum Discussion

jgc's avatar
jgc
New Member
7 years ago

Find significant change in a row

Hello everybody! I am trying to figure out how to identify significant change (increase or decrease) of datapoint in a row. We are dealing with data on weekly basis and I would like to see if one cu...
Need Help
jgc's avatar
jgc
New Member
7 years ago

Thank you very much for the suggestion!

 

I am still new to Power BI and try to understand how the solution works:

  • What does the NewIndex column do?
  • Can the solution matrix be modified to not to split in columns per starting week, so that "week 4", "week 6" and "-70%" would appear in the same columns as week 2?

Thank you very much for help!

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi jgc ,

     

    The NewIndex groups these values that have the same trend. Then we can count the trends easily. If the count is bigger than 3, it's the one you want. 

    The NewIndex 2 and 4 mean there are two trends (increase/decrease). Please refer to the below image to modify the result.

    Find-significant-change-in-a-row2

     

    Best Regards,

    • jgc's avatar
      jgc
      New Member
      7 years ago

      Thank you very much for the further details. I tried to implement your solution with our data, but it turned out that the solution is incredibly slow. We have about 30.000 rows at the moment and the data update would take for over a day!

       

      Any chance to get to a solution with another approach?

       

      Thanks in advance!