Best Practices with Measures in Power BI by Pragati Jain

Abstract:
Measures are one of the strongest ways of writing calculations in Power BI. They can be even used to achieve toughest functionalities in a more flexible way.
But do we always think of certain rules that can make these measures, say more readable for other report developers or using some best practices to be followed before we even start writing these expressions?
In this session, I will take you through some of the best practices that one should keep in mind while framing their DAX measures in Power BI. This will not only make your expressions easy to understand, but will also help other report developers interpret them in the correct way, so that they can re-use or extend them for reporting.
• Measure naming conventions
• Measure formatting
• Commenting measures
• Usage of Variables to simplify a measure
• Measure organisation using Folders
• Measure tables usage
The session will show some use-cases where these best practices have helped streamline the process.

About Pragati:
Pragati is a Data Platform MVP (Microsoft Most Valuable Professional).

Currently, she is working as a Manager at Avanade in UK and works towards generating and delivering data insights to various customers. She holds a Master’s degree in Data Science and Analytics from Royal Holloway University of London.
She is skilled in various tools and technologies like Microsoft Power BI, Tableau, Microsoft Excel, Azure ML Studio, Azure Databricks Pyspark and SQL.
She has been using Power BI for few years now and is recognised as a Superuser on the Microsoft Power BI Community.
Outside work she enjoys photography, loves hiking, she is a trained Indian classical singer and has a passion for painting. She even has her Instagram page dedicated to painting.

Microsoft MVP: https://mvp.microsoft.com/en-us/PublicProfile/5004163?fullName=Pragati%20Jain