Jan 07 2020 02:26 PM
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).
Jan 07 2020 03:31 PM - edited Jan 07 2020 03:33 PM
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
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