Calculated column with the sum of values from many columns in a row

0 votes

How to create calculated column with the sum of values from many columns in a row?

Mar 14, 2019 in Power BI by Nithin
2,607 views

1 answer to this question.

0 votes

Hi,

You can create a new column by clicking on new column under modelling tab in power bi.

Then Enter the code as 

  • Column name = Table_name[column_name 1] + Table_name[column_name 2] + Table_name[column_name 3].

Then a new column will be created from the sum of multiple columns.

Hope this helps you.

answered Mar 14, 2019 by Cherukuri
• 33,030 points
Hi,

Could you help provide a solution where the table may have more or less columns than the previous month, with different headers. Column A, B, C are always the same. Col C = TOTAL (value only - not formula).

Col D, E, F etc, contain values

I need to add a column which calculates the difference between TOTAL and the sum of other columns.

Since the table headers and number of columns will change each month it needs to be dynamic.

Any help appreciated.

Thanks

Rick

Hi, @Frostyr,

You can follow this regarding your query:

https://www.edureka.co/community/71307/last-10-days-data-based-on-date-time

Related Questions In Power BI

0 votes
1 answer

Dax: Sum of values from many columns in a row

Yes, you can. Try to "Unpivot other columns" ...READ MORE

answered Apr 3, 2019 in Power BI by Upasana
• 8,620 points
10,389 views
0 votes
1 answer

In DAX, how do I RETURN the sum of a calculated column from a DAX Table Variable (created via ADDCOLUMN)?

You can access column variables of previously ...READ MORE

answered Oct 8, 2020 in Power BI by Gitika
• 65,890 points
4,502 views
0 votes
1 answer

To expand all lists in a row of lists at the same time without recurring values

Can't promise simple, but I have something ...READ MORE

answered Feb 19, 2019 in Power BI by Upasana
• 8,620 points
6,118 views
+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,540 points
7,391 views
0 votes
1 answer

How to export Power Queries from One Workbook to Another with VBA?

Try solving it using the Workbook. Query ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
6,672 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
4,213 views
0 votes
1 answer

How can I search for multiple strings?

A simple solution is this: List.ContainsAny(Text.SplitAny("This is a test ...READ MORE

answered Oct 24, 2018 in Power BI by Upasana
• 160 points
4,662 views
0 votes
1 answer

Power Query Web request results in “CR must be followed by LF” Error

What I think is, it might look ...READ MORE

answered Oct 29, 2018 in Power BI by Shubham
• 13,490 points
1,864 views
0 votes
1 answer

Add Column Count_of_people across two tables to get the count of people from a city.

Hi Anitha, 1. Merge both tables, using City ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
1,125 views
0 votes
1 answer

How can I get a column value from previous row in Power Query?

Hi Sindhu, add this line as your ...READ MORE

answered Mar 18, 2019 in Power BI by Cherukuri
• 33,030 points
8,143 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP