Using VALUES in iterators - SQLBI Newsletter #302

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

Why and when you should use VALUES while iterating a table reference in DAX.
Read more

SQLBI REPLAY

Computing MTD, QTD, YTD in Power BI for the current period

This article describes how to use the DAX time intelligence calculations applied to the latest period available in the data, also known as the “current” period.
Read more

COMICS

AI BI Blunders

This comic has been generated by ChatGPT using the AI Comic Maker GPT and so many prompts...

Please, give us your feedback!

:) Smile

:| Meh

CLASSROOM COURSES

Mastering DAX in London

Last call, reserve your seat now:

London, UK - Oct. 1-3, 2025:
Mastering DAX

This is the only course in the UK for 2025!

#302 · Aug 2025

LEARNING

Course calendar

DATA MODELING - 3 DAYS

	Dec 2-4 - Amsterdam

Mastering DAX - 3 DAYS

	Oct 1-3 - London
	Oct 28-30 - Lugano
	Nov 4-6 - Amsterdam
	Nov 12-14 - Chicago
	Dec 8-10 - Austin

video courses

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

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI August 2025 updates August being a slow month for Power BI, we cannot find any news of general interest. However, the update is always worth the upgrade, even just for the many fixes that are not even listed. Are they maybe keeping the best news in store for September? Aug 12, 2025 · Microsoft
	• Download any Power BI report from the Power BI service Fabric Studio is becoming one of the must-have tools that are helpful even if you just use Power BI and not Fabric. This article explains how to install the tool and use it to download thin reports using the BBIP format. Aug 13, 2025 · Gilbert Quevauvilliers
	• Power BI TMDL view: benefits, security risks, and best practices TMDL view is a great feature, but you must be aware of the security risk of exposing model editing features (including TMDL view). Do not use this information as an excuse to block everything, but rather, use it to empower the right users. Aug 11, 2025 · John Kerski
	• Five minutes to wow 5 seconds to sign up, and 5 minutes to wow! Why did Microsoft stop using this phrase? This is the starting point for a long insightful article about AI and BI that includes the personal story of Kurt Buhler entering the data analytics world. Aug 14, 2025 · Kurt Buhler

SQLBI YOUTUBE CHANNEL