How to get descriptive statistics for multiple columns

[BrianJ]

@Helal,

I will ask @EnterpriseDNA to break this thread into a separate topic starting with post #5.

One question I have for you is whether using R is a possibility? Because what you could do is shape your data as needed in Power Query, invoke an R script from within Power Query to calculate the descriptive statistics you need easily and then have it output those results seamlessly back out to Power Query, all within the same query.

For an example of this technique, you can see our Data Challenge #11 write up, where we used the same approach to retrieve regression results that were then fed back into a Power B native scatterplot visual.

Power BI Challenge 11 - Covid 19 Reporting from Greg, Brian, Jarrett, and Mudassir

All, Introduction For a while, we’ve been planning to do a joint entry to explore the dynamics of collaborative Power BI development, in order to provide the Enterprise DNA community with a set of practical, tested recommended practices. Our ultimate plan is to use Analyst Hub as the primary mechanism to facilitate this collaboration, but the first time through we thought we would focus on the broader elements of learning to work together as a team, since each of us has only ever been the sole…

• Brian