Powerpivot SUM and GROUPBY

Copper Contributor

Hey guys,

 

looking for some guidance perform a SUM and GROUPBY using a calculated field in power pivot. I've included a screenshot of the sample set and the expected outcome (in yellow).

2020-01-07 16_22_35-Window.png

1 Reply

Hi @arod_22

 

Have you written any DAX Measures or created a Power Pivot Model before?

 

If so then  you could add Measures such as Number of Appts Set,  Number of Appts Kept   etc

(let me know if you've written measures before)

 

If not then it will be tricky to teach you this in this forum but there's lots of great resources out there such as Excel is Fun by Mike Girvin  https://www.youtube.com/watch?v=yjASjwJCIxA

 

However, another approach would be to add a helper column to your data  (see attached file)

 

I used Calculated fields in the attached example to do the %s

 

clipboard_image_0.png

 

clipboard_image_1.png

 

 

clipboard_image_2.png

Hope that helps

 

Wyn

MVP

Australia (UTC + 8 )8)

 

If this answer was the best response please click the button

I also happily accept likes