Forum Discussion
SUM different row
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 !
Quick question, do you want the summed up data listed in the table itself or during runtime in a visual?
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
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
Thank you for your reply, the table of my OP was an exemple, if I change the name as below, I'm sure if this would work ?
Col1 Value Total External Revenue US 100 Internal Revenue US 200 External Revenue GBP 300 Internal Revenue GBP 400 Global Revenue US Global Revenue GBP Hi Sabri,
Yes, it should work if you change the formula like this...
Regards