Introduction to evaluation contexts and relationships
Row context and relationships
Filter context and relationships
CALCULATE examples
Filtering many columns
Filter arguments in CALCULATE
FILTER and CROSSFILTER functions
HASONEVALUE function
ALLSELECTED function
Context transition
Automatic CALCULATE in measures
Equivalent filter context
Circular dependency
Conclusions about relationships
CALENDAR function
CALENDARAUTO function
Mark as Date table
Set sorting options
Multiple dates
2
Introduction to iterators
Example: daily average
Useful iterators
MIN-MAX sales per customer
Statistical and financial functions
RANKX function and examples
Introduction to time intelligence
Aggregations over time
Year to date functions
Previous year and DATEADD functions
Example: previous year calculation
PARALLELPERIOD function
Running total
Moving annual total
Semi additive measures
Calculations over weeks
Time intelligence conclusions
EVALUATE syntax
FILTER and CALCULATETABLE functions
SUMMARIZE and SELECTCOLUMNS functions
CROSSJOIN function
GENERATE function
Tables, relationships, and data lineage
ROW, LOOKUPVALUE, and CONTAINS functions
TOPN function
UNION, INTERSECT, and EXCEPT functions
SUMMARIZECOLUMN and GROUPBY functions
Parameters in queries
DAX measures in MDX queries
Querying in DAX - conclusions
Introduction to advanced filter context
Filter propagation and strange results
Key topics
Base tables and expanded tables
Context propagation
Filter is on columns, not tables
Filter context operators
KEEPFILTERS function
3
Introduction to hierarchies
Parent-child hierarchies
Hiding levels in parent-child hierarchies
Ambiguity in bidirectional filters
USERELATIONSHIP function
Multi-column relationships
Static segmentation
Dynamic segmentation
Working at different granularity
Many-to-many relationships
Using bookmarks
Arranging bookmarks
Bookmarks as a slide show
Visibility - using the Selection pane
Bookmarks for shapes and images
Bookmark groups
Using Spotlight
Bookmarks in the Power BI service
Creating the BACK button
Understanding Default, Hover and Select
The DEFAULT formatting
Using Numeric slicers
Formatting the numeric inputs
Formatting the slider
The developer API
Create Power BI visuals using R
Recommanded Books
Title
Teach Yourself Visually Power BI
ISBN
978-1-119-90377-2
Author
Alexander Loth
Year
2023
Publisher
Visual
Title
Artificial Intelligence with Microsoft Power BI: Simpler AI for the Enterprise
ISBN
978-1-098-11275-2
Author
Jen Stirrup, Thomas Weinandy
Year
2024
Publisher
O'Reilly Media
Title
Data Cleaning with Power BI: The definitive guide to transforming dirty data into actionable insights
ISBN
978-1-805-12640-9
Author
Gus Frazer
Year
2024
Publisher
Packt Publishing
Title
The Complete Power BI Interview Guide: A modern approach to acing the data analyst interview and landing your dream job
ISBN
978-1-805-12067-4
Author
Sandielly Ortega Polanco, Gogula Aryalingam and Abu Bakar Nisar Alvi
Year
2024
Publisher
Packt Publishing Pvt Ltd
Title
Effective Strategy Execution: Business Intelligence Using Microsoft Power BI (Management for Professionals)
ISBN
978-3-662-68806-9
Author
Bernd Heesen
Year
2024
Publisher
Springer
Title
Power BI Machine Learning and OpenAI: Explore data through business intelligence, predictive analytics, and text generation
ISBN
978-1-837-63615-0
Author
Greg Beaumont
Year
2023
Publisher
Packt Publishing
Title
Pro Power BI Architecture: Development, Deployment, Sharing, and Security for Microsoft Power BI Solutions
ISBN
978-1-484-29537-3
Author
Reza Rad
Year
2023
Publisher
Apress
Title
Mastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence, 2nd Edition
ISBN
978-1-801-81148-4
Author
Greg Deckler, Brett Powell
Year
2022
Publisher
Packt Publishing
Title
Up and Running with DAX for Power BI: A Concise Guide for Non-Technical Users
ISBN
978-1-484-28187-1
Author
Alison Box
Year
2022
Publisher
Apress
Title
Pro Power BI Dashboard Creation: Building Elegant and Interactive Dashboards with Visually Arresting Analytics
ISBN
978-1-484-28226-7
Author
Adam Aspin
Year
2022
Publisher
Apress
Title
Pro Data Mashup for Power BI: Powering Up with Power Query and the M Language to Find, Load, and Transform Data
ISBN
978-1-484-28577-0
Author
Adam Aspin
Year
2022
Publisher
Apress
Title
Power BI Data Modeling: Build Interactive Visualizations, Learn DAX, Power Query, and Develop BI Models
ISBN
978-9-389-32883-7
Author
Nisal Mihiranga
Year
2022
Publisher
BPB Publications
Title
Power BI for Jobseekers: Learn how to create interactive dashboards and reports, and gain insights from the data
ISBN
978-9-355-51814-9
Author
Alan Murray
Year
2023
Publisher
BPB Publications
Title
Learning Microsoft Power BI: Transforming Data into Insights
ISBN
978-1-098-11284-4
Author
Jeremey Arnold
Year
2023
Publisher
O'Reilly Media
Title
Applied Microsoft Power BI: Bring your data to life!
ISBN
978-1-733-04613-8
Author
Teo Lachev,Edward Price,Maya Lachev,Martin Lachev
Year
2022
Publisher
Prologika
Title
Microsoft Power BI For Dummies
ISBN
978-1-119-82487-9
Author
Jack A. Hyman
Year
2022
Publisher
For Dummies
Title
Microsoft Power BI Performance Best Practices: A comprehensive guide to building consistently fast Power BI solutions
ISBN
978-1-801-07644-9
Author
B. Merchant, C. Webb
Year
2022
Publisher
Packt Publishing
Title
Learn Power BI: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence, 2nd Edition
ISBN
978-1-801-81195-8
Author
Greg Deckler
Year
2022
Publisher
Packt Publishing
Title
Introducing Charticulator for Power BI: Design Vibrant and Customized Visual Representations of Data
ISBN
978-1-484-28075-1
Author
A. Box
Year
2022
Publisher
Apress
Title
Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level
ISBN
978-1-801-07851-1
Author
Michiel Rozema, Henk Vlootman
Year
2022
Publisher
Packt Publishing
Title
Mastering Power BI: Build Business Intelligence Applications Powered with DAX Calculations, Insightful Visualizations, Advanced BI Techniques, and Loads of Data Sources
ISBN
978-9-391-03072-8
Author
Chandraish Sinha
Year
2021
Publisher
BPB Publications
Title
The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel
ISBN
978-1-509-30697-8
Author
Marco Russo, Alberto Ferrari
Year
2019
Publisher
Microsoft Press
Title
Supercharge Power BI: Power BI Is Better When You Learn to Write DAX
ISBN
978-1-615-47069-3
Author
Matt Allington
Year
2018
Publisher
Holy Macro! Books
Title
Power BI: Moving Beyond the Basics of Power BI and Learning about DAX Language
ISBN
B089XYQCVR
Author
Mike Morris, Nick Gallagher, et al.
Year
2020
Publisher
Albano Publishing LLC
Title
DAX Cookbook: Over 120 recipes to enhance your business with analytics, reporting, and business intelligence
ISBN
978-1-839-21707-4
Author
Greg Deckler
Year
2020
Publisher
Packt Publishing
Title
Hands-On Business Intelligence with DAX
ISBN
978-1-838-82863-9
Author
Ian Horne
Year
2020
Publisher
Packt
Title
Applied DAX with Power BI: From zero to hero with 15-minute lessons
ISBN
978-1-733-04610-7
Author
Lachev, Teo
Year
2019
Publisher
Prologika Press
Title
DAX Patterns
ISBN
978-1-735-36520-6
Author
Russo, Marco; Ferrari, Alberto
Year
2020
Publisher
SQLBI Corp.
Title
Supercharge Excel: When you learn to Write DAX for Power Pivot
ISBN
978-1-615-47053-2
Author
Matt Allington
Year
2018
Publisher
Holy Macro! Books
Title
Pro DAX with Power BI: Business Intelligence with Powerpivot and SQL Server Analysis Services Tabular
ISBN
978-1-484-24896-6
Author
Philip Seamark; Tom Martens
Year
2019
Publisher
Apress
Title
Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence
ISBN
978-1-484-23476-1
Author
Philip Seamark
Year
2018
Publisher
Apress
Title
Collect, Transform and Combine Data using Power BI and Power Query in Excel (Business Skills)
ISBN
978-1-509-30795-1
Author
Gil Raviv
Year
2018
Publisher
Microsoft Press
Title
Analyzing Data with Power BI and Power Pivot for Excel
.jpg)
.jpg){kind=spacer}
