DAX Tools is a completely free video course designed to guide you through the best DAX tools available. At the time of launching, the video course includes:

• DAX Studio
• VertiPaq Analyzer
• Analyze in Excel for Power BI Desktop

We will also be publishing these videos on YouTube over the coming weeks. By enrolling for free now on www.sqlbi.com, you can enjoy immediate access to the entire video course through the SQLBI platform with videos, transcripts, translations, bookmarks, dark mode, a customizable layout, comments, progress tracking, your own completion certificate, and demo files!
Enroll now

Using the SELECTEDVALUE function in DAX 12:27 Alberto Ferrari

Previous year up to a certain date 5:48 Alberto Ferrari

Apply AND Logic to Multiple Selection in DAX Slicer 12:50 Alberto Ferrari

	• DirectQuery for Power BI datasets and Azure Analysis Services This is the official announcement of THE big news in this newsletter. You also have the official name, too long to be useful. DQAS is the acronym often used by technical people, and we like the more popular "new composite models". Which name will you use to identify these models in the coming years? Dec 16, 2020 · Microsoft
	• Power BI December 2020 update Microsoft releases other interesting features in this monthly update: beside the many small details you can find in the official announcement, there are separate articles for small multiples (only in certain chart types) and protection sensitivity labels to identify sensitive data in your reports. Massive update before the holidays! Dec 16, 2020 · Microsoft
	• On-premises data gateway December 2020 The monthly update of this data gateway is aligned with the mashup engine of Power BI. Remember that starting in February 2021, the .NET 4.8 framework shall be a new prerequisite. If the operating system of your gateway is Windows Server, or a Windows client older than the Windows 10 May 2019 update, then you have to make sure to install the right .NET version! Dec 8, 2020 · Microsoft
	• Capturing SQL queries generated by a Power BI DirectQuery dataset A paginated report connected to a Power BI dataset that uses DirectQuery can take advantage of Power Query parameters passed to the DAX functions. This way, the parameters in your report can reach the DirectQuery data source. Dec 13, 2020 · Chris Webb
	• Single-letter day and month names in Power BI If you want to display a chart using the first letter of the day (S-M-T-W-T-F-S), then you have to manage the sort order, and the duplicated names. This blog post explains a practical approach in both M and DAX. Dec 11, 2020 · Daniil Maslyuk