Forum Discussion

hmokkapati's avatar
hmokkapati
Icon for Helper II rankHelper II
9 years ago
Solved

Matrix - row total formula

Hello,   I have line items (rows) in a matrix and I would need the Total to be calculated differently for different line Items. For ex, it needs to add all monthly values for one and avg for others...
Need Help
  • hmokkapati's avatar
    hmokkapati
    9 years ago

    Bhavesh and Angelia, thanks for your response.

     

    For now, i got around the problem by getting the Yearly totals from the source itself. This is being calculated in the source data so i am able to pull it in.

     

    But surely would like to know how such requirements (P&L items) are handled in Power BI. Looks like there is better control in excel as we can manipulate (even in terms of formatting) at cell level once the pivot table is placed on the sheet.

     

    Thank you,

    Harisha

dchager's avatar
dchager
Regular Visitor
9 years ago

Have you ever used a pivot table for this? If not possible, it is unlikely that row total can be done in Power BI desktop.

  • hmokkapati's avatar
    hmokkapati
    Icon for Helper II rankHelper II
    9 years ago

    Thanks for your reply.

     

    By pivot, you mean in excel right? Our customer has requirement for both excel and PowerBI. Not sure how to achieve this for Matrix in Power BI.

     

     

    Thank You,

    Harisha