Est. 2002
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[FROM] && tblProjects[Variance %] <= tblBands[TO]
))
If you would like to work along with the Excel file that accompanies this tutorial you are more than welcome to download it here.
Computer Tutoring takes your privacy seriously and collects essential information such as your name, email, and course preferences to facilitate our services. Additionally, we use cookies to personalise your experience and for Google Ads personalisation, which helps us deliver more relevant advertising to you.
We do not share your personal data, except for specific use-cases like payment processing via PayPal and sending you updates via Mailchimp, if you've opted in for those services. Our site may also use Google Analytics to improve user experience and features links to other websites. Please be aware that Google's Privacy Policy may differ from ours.
We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.
By using our website, you consent to our use of cookies for the purposes outlined above.
For more details, please read our full Privacy Policy.