Forum Discussion

bullius's avatar
bullius
Icon for Helper V rankHelper V
10 years ago
Solved

Table with SUM values

Hi   I want to produce a table with SUM values. My data looks something like this:   Current data:   Code Year Type Amount A 2013 Type 1 10 A 2013 Type 1 20 A 2013 Type 2...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

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

     

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

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

 

bullius's avatar
bullius
Icon for Helper V rankHelper V
10 years ago

That works, thanks!