THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » DAX   (RSS)
Showing page 1 of 14 (134 total posts)
  • Back to the basic: #dax primers for new #powerbi users

    The growing adoption of Power BI Desktop is gathering new users of the DAX language. At the same time, there are a few new features, such as bidirectional filter propagation, that introduce new concepts to existing knowledge. For this reason, in the last weeks we published two articles describing important basic concepts and clarifying the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 7, 2015
  • Power BI Desktop & Excel

    The August 2015 update of Power BI Desktop added two important features for existing Excel and Analysis Services users:Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop fileLive Analysis Services Connections: Ability to change the database from Edit Queries dialogIn case you didn't try it before, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 31, 2015
  • DAX Formatter now supports Power BI Desktop and Excel 2016 #dax #powerbi

    If you use DAX, you should try DAX Formatter. Now it supports all the new functions introduced in Power BI Desktop and in Excel 2016. There are more than 70 new functions, even if half of them corresponds to Excel functions with the same name (see the second group). DAX Formatter also supports the variable syntax available in the new DAX. These ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 18, 2015
  • The ALLSELECTED function under the cover #dax #tabular #powerpivot #powerbi

    I and Alberto Ferrari recently completed the writing of The Definitive Guide to DAX, and we spent months to correctly describe the internals of evaluation context in this language. There are many details that make data model working with both DAX and MDX, and sometime there are behaviors that are not intuitive to understand. A function that seems ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 5, 2015
  • The new Power BI Desktop is here #powerbi #dax

    After months of public preview, Microsoft today is releasing the Power BI service to general availability. The preview was really a beta that evolved in these months, and I personally liked the approach that MS developers have now. I did not read the “it’s by design” answer to the many comments and suggestions provided in support forums and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 24, 2015
  • DAX Studio 2.2 released - tracing support for #powerpivot and much else! #dax

    Thanks to Darren Gosbell we have DAX Studio 2.2. In this new release:Tracing (query plans and server timings) available for Power PivotBasic implementation of IntellisenseConnect to Multidimensional SSAS serversSupport for multiple Power BI Desginer instancesHighlight unnatural hierarchies (read here why this is so important for ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 24, 2015
  • New features in DAX Editor #dax #tabular #ssas

    In the last few weeks I and Teo Lachev took the ownership of DAX Editor code. It is an add-in for Visual Studio that allows you to edit DAX measures in a text editor instead of using the Measure grid. It also provides other features (such as editing measures of an online Tabular database and performing a few queries). The user interface is not ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 7, 2015
  • DAX Studio 2.1 helps you optimizing #dax queries for #powerpivot #powerbi #ssas #tabular

    After the initial release of DAX Studio 2.0, in December 2014, I started working on a few features to analyze performance of DAX queries. Darren Gosbell implemented many other features, and Daniele Perilli helped us with the graphics of the UI. We certainly can do more, but I think that the current feature set of the new release is good enough to ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 17, 2015
  • New article in the From SQL to DAX series: IN and EXISTS functions in #DAX

    I published another article in the “From SQL to DAX” series I launched many months ago on www.sqlbi.com. This time, the goal is to analyze DAX alternatives for IN and EXISTS operators that you have in SQL. The name of the article is From SQL to DAX: IN and EXISTS. I hope that a syntax corresponding to the SQL operator IN will be available in ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 11, 2015
  • Use FIRSTNONBLANK and LASTNONBLANK instead of MIN and MAX #dax

    You are probably used to think to FIRSTNONBLANK and LASTNONBLANK as DAX functions related to time-intelligence calculations (usually for semi-additive measures). However, these functions have a syntax and a behavior that can be useful in other scenarios. For example: you might be aware that MIN and MAX cannot be used with text columns. However, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 24, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement