Forum Discussion

vkisa's avatar
vkisa
Helper II
2 years ago
Solved

Creating Custom Subrows as Percentage Changes

Hi, I need to add a subrow that calculates of percentage change for between specific 2 different time periods as below.     Type Sum of Revenue Yesterday 229,925.28 SDLM 196,666.63 ...
"DAX help"
Hierarchy of matrix
  • lbendlin's avatar
    lbendlin
    2 years ago

    Here is the general approach

     

    note that you cannot mix data formats unless you convert everything to to text.

     

lbendlin's avatar
lbendlin
Super User
2 years ago

Here is the general approach

 

note that you cannot mix data formats unless you convert everything to to text.

 

  • vkisa's avatar
    vkisa
    Helper II
    2 years ago

    Thank you lbendlin , but I need to percentage of change for Variance1 and Variance2 levels rather than 1. Is it possible to define a measure on there?

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      yes, that's what you need to do. Replace the "1"  with the appropriate measure.

      • vkisa's avatar
        vkisa
        Helper II
        2 years ago

        I guess, we can not hide the blank Type_General row, while the subrows appear,right?