cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DC9000
Frequent Visitor

Creating a calculated column

Hi, I'm fairly new to Power Bi and I'm not understanding how to do this.

Let's say I have table (1) and I want to create table (2):
(1)Starting tableStarting table

(2)What I wantWhat I want
I managed to create table (3), but I want to create a calculated column like the one in table (2)
(3)end0.jpg

I don't know how to summarize in a calculated column.
Any help would be greatly appreciated, 
thanks

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @DC9000 ,

 

to get rid of rows, you always have to use Power Query. A calculated column just adds a new column, but it will not combine rows.

In your case you need a group by with the following criteria:

selimovd_0-1627377854844.png

Then the result will look like this:

selimovd_1-1627378063218.png

 

 

Check the video I created on how to do that, it's pretty easy:

groupby.gif

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

3 REPLIES 3
selimovd
Super User
Super User

Hey @DC9000 ,

 

to get rid of rows, you always have to use Power Query. A calculated column just adds a new column, but it will not combine rows.

In your case you need a group by with the following criteria:

selimovd_0-1627377854844.png

Then the result will look like this:

selimovd_1-1627378063218.png

 

 

Check the video I created on how to do that, it's pretty easy:

groupby.gif

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

DC9000
Frequent Visitor

Thank you for your solution, I will try it out.
Let's say I don't care about rows, i.e. I want every rows to display the sum of "Value" for every "Name", how would you do that?

Hey @DC9000 ,

 

you can add a calculated column and ignore all the row context except for the Name. The following calculated column will do that:

Total Value by Name =
CALCULATE(
    SUM( 'myTable'[Value] ),
    ALLEXCEPT(
        'myTable',
        'myTable'[Name]
    )
)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!