SQLBI Newsletter #283

NEW ARTICLE

Blank in date columns and DAX time intelligence functions

This article explores the implications of having blank values in date columns and provides the best practices for managing them in DAX calculations and Power BI reports.
Read more

SQLBI REPLAY

Understanding blank row and limited relationships

DAX creates a blank row to guarantee that results are accurate even if a regular relationship is invalid. The blank row is not created for limited relationships. This article shows the effect of not having a blank row in your tables.
Read more

#283 · Dec 2024

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	Dec 2-4 - Copenhagen
	Feb 11-13 - Amsterdam
	Feb 18-20 - Phoenix
	Feb 24-26 - Dallas

DATA MODELING - 3 DAYS

	Dec 10-12 - Amst

video courses

	Mastering Tabular
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	DAX Tools
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	DAX Patterns

BI-WEEKLY NEWS DIGEST

Latest news

	• SQL database in Fabric Among the many announcements made at Microsoft Ignite, it worth to mention the SQL database in Fabric, which finally closes a gap we had in Power BI for many years. Nov 23, 2024 · Marco Russo
	• Introducing the Core Visuals Vision Board Microsoft shared the plans for the core visuals showing an amazing dashboard that you can use also to vote ideas that prioritize upcoming features. Nov 26, 2024 · Microsoft
	• Geoanalysis with Power BI: transform latitude and longitude into country, state, and territory This article describes how to determine in DAX which polygon includes a point (Point in Polygon), which can be useful for a large variety of use cases. Nov 3, 2024 · Markus Boehm

SQLBI YOUTUBE CHANNEL

Latest videos

Compare DAX Optimizer vs ChatGPT vs Copilot for Power BI