SUM FOR BIG ROW

Hi amaher 

Your table is not in the best format for reporting. Each period must have its own row as below.

In the query editor, select the first two columns and click unpivot other columns. Please refer to this - https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098 
This is Power Query in Excel but the GUI is about the same as in Power BI.

amaher 

you can also try this in PQ

=List.Sum(List.Skip( Record.ToList(_),2))

thanks all, i solve this by go to PQ and select wich columns i need to calculate thire row and creat table with auto sum for it,

i don't know if this the best solution or not

Thanks for the reply from ryan_mayu and danextian, your replies are all fantastic!

Hi amaher ,

I used the code ryan_mayu provided and was able to achieve the results you are looking for! I tried another logic and was able to implement it successfully as well.

List.Sum(Record.ToList(Record.SelectFields(_, List.Skip(Record.FieldNames(_), 1))))

In addition to providing the error message you encountered, could you please provide example data or sample files here if you have any confused? We could offer you more help if we have information in detail. There is sensitive data that can be removed in advance. How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.