SQLBI Newsletter #197

NEW ARTICLE

This article explains how the CONTAINS function works, and what are better alternatives in DAX in common use cases. Depending on the use case, TREATAS, INTERSECT, and EXCEPT could be faster and easier to write.
Read more

#197 · Aug 2021

LEARNING

Course calendar

video courses

DAX PATTERNS

Custom time-related calculations

This pattern shows how to compute time-related calculations like year-to-date, same period last year, and percentage growth using a custom calendar. This pattern does not rely on DAX built-in time intelligence functions. All the measures refer to the fiscal calendar because the same measures, with a regular Gregorian calendar, can be obtained using the Standard time-related calculations pattern.
Read more

SQLBI YOUTUBE CHANNEL

Latest news

	• Power BI August 2021 Update The Power BI August 2021 update has new formatting options for buttons and custom shapes, plus a new way to define date and time constant values without using the DATE and TIME functions. Aug 13, 2021 · Microsoft
	• Enhanced experience for browsing visuals in Power BI The August 2021 update also has a new browsing experience for custom visuals in Power BI. While the search experience and the classification of the visuals can still be improved, the new visualization is certainly a step forward. Aug 10, 2021 · Microsoft
	• Power BI REST API support for DAX Queries Microsoft started the preview of a new REST API to get data from Power BI service by running custom DAX queries. This REST API does not use XMLA endpoint and it works on any Power BI subscription, including Power BI Pro. You got that right - no Premium needed. If you want to export data from your dataset to another cloud service, this is a game changer. Aug 2, 2021 · Ben Gribaudo
	• Excel Cube functions, dynamic arrays and lambdas, part 3: grouping and histograms This new post in the series dedicated to the Lambda helper functions in Excel shows how to dynamically create arguments for the CUBESET and CUBEVALUE functions to create dynamic reports connected to Power BI models. Aug 8, 2021 · Chris Webb

View Web Version · Change Email Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.