Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SUM different row

Hi, I'm a beginner in Power BI and I have (I think?) a simple question:   I have currently this table (Total is a calculated column)   Col1 Value Total A1 100   A2 200   B1 30...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    Sorry for the late reply, I was in vacation.

     

    I'm not sure if this is the right method by the admin to mark a reply as solved, that's definetly NOT the solution that I was looking for. Having admin rights doesn't mean you can do whatever you want...

     

    The right way that I did is:

    1) Pivot those rows into columns in Power BI Queries with language M.

    2) Create a calculated column to sum up the new pivoted columns.

    3) Unpivot those columns into rows.

     

    This wroked great !

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi epappu,

 

In the table itself.

 

Visual function are used for sum only, the issue is that I need to use some soustraction and divide formula as well.

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Sabri - 

 

I tried to do a similar dataset in a local pbi file, and please see the screengrab below. I think this will help you get your totals irrespective of how many rows you have starting with A or B.

 

 

If this helped you, please accept this as solution.

 

Regards