Table with SUM values

Question

Hi&nbsp;I want to produce a table with SUM values. My data looks something like this:&nbsp;Current data:&nbsp;CodeYearTypeAmountA2013Type 110A2013Type 120A2013Type 21A2013Type 22A2014Type 140A2014Type 24A2015Type 135A2015Type 23B2014Type 15B2014Type 110B2014Type 120B2014Type 2100B2014Type 2200B2014Type 2150B2015Type 150B2015Type 2300&nbsp;Table I want to produce:&nbsp;CodeYearType 1 SumA201330A201440A201535B201435B201550&nbsp;As you can see, I want the sum of [Amount] filtered by [Type], grouped by [Code] and [Year].&nbsp;I have tried a few different formulas, but can't get anything to work.&nbsp;Any help appreciated!

ankitpatira · Accepted Answer

bullius&nbsp;Go to power bi desktop query editor, under Transform tab click Group by and apply it as shown below.&nbsp;

Forum Discussion

Related content

Formatting Value of Table

PowerBI - Matrix table, hide values used only for a visual calculation

Table Call Value Formatting Options

Parsing list values in a nested table

SUMMARIZE, VALUES, and other table generation/manipuation with field parameters