Forum Discussion
Creating a calculated column
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
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:
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic