DAX, SQL and R…grouping and summarizing data.

With examples of course!

Photo by Nathan Dumlao on Unsplash

Everyone has to summarize data at some point. Here is how to do it in Power BI’s DAX, SQL and R.

This is a simple data set I have with 3 columns.

It’s basically the price for natural gas from 1997 to 2022.

Let’s say I want to know the Average, Min, Max and a difference column of Max —…