SQLBI Newsletter #245

NEW ARTICLE

RANK is a new DAX function to rank items based on multiple columns. This article introduces the RANK function and its differences with RANKX.
Read more

#245 · Jun 2023

LEARNING

Course calendar

Mastering DAX

	Jun 20-22 - Sydney
	Jun 26-28 - Brisbane
	Jun 27-29 - Amsterdam
	Sep 19-21 - Amsterdam
	Sep 27-29 - Chicago
	Nov 6-8 - Atlanta

Data Modeling

	Nov 7-9 - Amsterdam

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

	• Power BI June 2023 Update This month, Power BI Desktop has two new important features with more details in separate news: the Developer Mode and a new card visual. Yes, plus many updates to on-object interaction, documentation, and edit model in the data service. Jun 14, 2023 · Microsoft
	• Deep dive into Power BI Desktop Developer Mode There is a new file format - PBIP, Power BI Project - which is not a single file, but an entire folder structure that splits the Power BI definitions in different files, in order to support source control and continuous integration. The impact is wide, because external tools too can benefit from the new features. We are only at the beginning of a new chapter. Jun 15, 2023 · Microsoft
	• New card visual in public preview The new card visual solves many of the issues and limitations of the original version. Card with States by OKVIZ has been one of the few alternatives for a long time, but now there is a native visual that can display multiple measures generating a single query, and you have more control over many settings. Jun 13, 2023 · Microsoft
	• Understanding licensing for Microsoft Fabric from a Power BI perspective Capacity, users, licenses: Fabric and Power BI have difference licensing models that can make life difficult if you are used to the simple Power BI per user model. However, a few tables and a schematic description help a lot! Jun 15, 2023 · John White
	• Power Query templates in Excel and Fabric Fabric introduced Gen2 Dataflows. Out of the box, you can use migrate a Power BI Gen1 Dataflow to Fabric, but in reality it is also possible to migrate a transformation from Power Query in Excel to Gen2 Dataflows. Jun 11, 2023 · Chris Webb

SQLBI YOUTUBE CHANNEL