Microsoft Power BI Visual Calculations: Simplifying DAX

Description

Seasoned experts Jeroen ter Heerdt, Madzy Stikkelorum, and Marc Lelijveld help you master visual calculations in Power BI for transformative data insights Microsoft Power BI Visual Calculations: Simplifying DAX is a comprehensive guide that demystifies the innovative feature of visual calculations in Power BI. Jeroen, a Principal Product Manager at Microsoft, Madzy, a Data Analytics Consultant, and Marc, a Microsoft Data Platform MVP, bring their extensive expertise to this book, offering you a practical approach to mastering visual calculations. The book is designed to simplify DAX, making it accessible to beginners and empowering you to transform raw data into actionable insights. You will learn to implement visual calculations, understand their benefits, and apply them effectively in real-world scenarios, ultimately enhancing your ability to make data-driven decisions.

By reading this book, you will:

• Understand the fundamentals of visual calculations in Power BI
• Create your first visual calculation with step-by-step guidance
• Explore advanced concepts like resetting context in visual calculations
• Compare visual calculations with other Power BI calculation options
• Master the performance characteristics of visual calculations
• Utilize specific functions designed for visual calculations
• Implement practical use cases like running sums and moving averages
• Enhance visual calculations with regular DAX expressions
• Optimize operational processes using data-driven insights
• Unlock the full potential of Power BI for strategic decision-making

About This Book

• For Power BI users who want to simplify DAX and unlock the full potential of visual calculations without the usual complexities
• For business executives, managers, and data enthusiasts looking to transform raw data into actionable insights for strategic decision-making

Sample Content

Table of Contents

Part I     Visual calculations fundamentals

Chapter 1           Introduction to visual calculations 

Chapter 2           My first visual calculation      

Chapter 3           Visual calculations concepts               

Chapter 4           Organization and use of visual calculations

Part II    Visual calculations functions

Chapter 5           The pillars: supportive functions       

Chapter 6           The foundation: foundational functions       

Chapter 7           The floors and rooms: visual calculations exclusive functions     

Part III  Mastering visual calculations

Chapter 8           Comparing calculation options         

Chapter 9           Breaking down visual calculations execution           

Part IV  The art of practical visual calculations

Chapter 10        Applied visual calculations  

Chapter 11        Charting with visual calculations     

Chapter 42        Beyond the page

Updates

Submit Errata