Forum Discussion
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) (2) I managed to create table (3), but I want to ...
Hey Anonymous ,
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:
Then the result will look like this:
Check the video I created on how to do that, it's pretty easy:
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
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 Anonymous ,
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
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic