Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Calculated budget % share row (calculated row?)

Hi,

 

I have a pretty normal matrix layout below. But I need to add a budget (without regional or branch splits) to row 10 and a % variance versus budget row in row 11. Please can you tell me how to do this in Power BI?

 

 

Thanks for your help,

 

CM

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

     

    You can refer to below sample if it suitable for your requirement.

     

    Tables:

     

    Table formula:

     

    SummaryTable = UNION(FirstTable,SecondTable,SELECTCOLUMNS(SUMMARIZE(FirstTable,FirstTable[Month],"Value",SUM(FirstTable[Value])),"Region","Summary","Branch","Total","Month",[Month],"Value",[Value]))

     

     

     

    Regards,

    Xiaoxin Sheng

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Does my question make sense?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      If it's impossible to do this please can someone confirm? How about if I create table 2 below, is this possible? Can I create calculated rows in a table like this (rather than calculated columns?)?

       

       

       

      Thanks for any help,

       

      CM

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Anonymous,

         

        You can refer to below sample if it suitable for your requirement.

         

        Tables:

         

        Table formula:

         

        SummaryTable = UNION(FirstTable,SecondTable,SELECTCOLUMNS(SUMMARIZE(FirstTable,FirstTable[Month],"Value",SUM(FirstTable[Value])),"Region","Summary","Branch","Total","Month",[Month],"Value",[Value]))

         

         

         

        Regards,

        Xiaoxin Sheng