Computer Tutoring Logo
Est. 2002
Menu Button

Power BI Group Values


How to group values in Power BI?

Grouping values in Power BI is particularly handy especially when you do so in the form of a DAX formula. This tutorial takes advantage of the CALCULATE function in DAX. To group values, in this case variances, by means of a formula allows you to set the values. Rather than simply using the Group By option that comes as standard in Power BI. Although the Group by Data option is extremly helpful.

The formula used in the above tutorial is:

BAND = CALCULATE(VALUES(tblBands[Band]),
FILTER(tblBand,tblProjects[Variance %] >= tblBands[Variance %] && tblProjects[Variance %] <= tblBands[Variance %]
))

If you would like to work along with the Excel file that accompanies this tutorial you are more than welcome to download it here.