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 » Power BI   (RSS)
Showing page 2 of 7 (65 total posts)
  • The new data modeling book for Power BI and Power Pivot users

    In the last few years, I and Alberto Ferrari assisted many users of Power Pivot and Power BI who wanted to create their reports using these tools and were struggling with getting the desired numbers from their data. The first approach of an Excel user is to look for a function, or a more complex DAX expression, that can implement the calculation ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 7, 2017
  • Avoid measure and column with the same name in #dax

    I recently wrote an article about duplicated names in DAX to highlight a possible case where you can have a measure with the same name of a column. This is not a good idea, mainly because the syntax to reference a measure and a column is identical, and this similarity is the root of a number of issues. It would be much better if the measure ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 2, 2017
  • Using and optimizing DirectQuery in #powerbi and #ssas #tabular

    More than one year ago, I and Alberto Ferrari started to work on DirectQuery, exploring the new implementation appeared in Analysis Services 2016 for the Tabular models, which uses the same engine of Power BI. The previous version of DirectQuery appeared in SSAS Tabular 2012 was very slow and suffered of performance issues also using small models. ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 19, 2017
  • PASS Business Analytics Marathon (March 2017) - Recordings Available!

    The sessions of the event PASS Business Analytics Marathon, held last March 2017 on 29th, were recorded and now they are available for online streaming! If you have missed one session in particular or the entire event, you can view or review your preferred topics. Each video is available on detail page of the related session, you can find the ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on April 14, 2017
  • PASS Business Analytics Marathon (March 2017)

    The next edition of the live event PASS Business Analytics Marathon will be on March 29, 2017. This edition of Business Analytics Marathon will consist of five webinars on the following topics:Data Driven StorytellingData DiscoveryPower BIThe schedule is available here. Thanks to the Sponsors, the event will be free of charge, register ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 24, 2017
  • Unexpected side effects of table filters in #dax

    One of the side effects that you might not expect from a table filter in a CALCULATE statement is the removal of an existing filter. In reality, this is a condition that happens when you write an explicit CALCULATE in a row context, because the table filter overrides the context transition in case you filter the same table that generated the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 21, 2017
  • New syntax in DAX: IN operator, table and row constructors #dax #powerbi

    I recently wrote an article to described in more details the syntax of the IN operator in DAX, which is available in Power BI and in the CTP of the next release of Analysis Services. Jeffrey Wang wrote a blog post about the IN operator a few months ago, so I waited some time to include more details about how it internally works ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 7, 2017
  • Mark as Date table in Power BI #dax #powerbi

    One year ago I wrote an article describing how the time intelligence DAX functions work in Power BI (I just updated the article including the example described below). In a recent event in Sydney I observed a strange (or at least unexpected) behavior of Power BI during a demo, and I think it is interesting to share a few considerations ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 21, 2017
  • Using SUMMARIZECOLUMNS instead of SUMMARIZE in #dax #powerbi #ssas #tabular

    One of the latest addition to DAX has been the ability to apply an external filter context to SUMMARIZECOLUMNS, which makes this function a perfect replacement for SUMMARIZE in DAX. In The Definitive Guide to DAX I introduced such a function, but at the time of writing it was used only by Power BI and it wasn’t possible to include it in a measure, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 2, 2017
  • Year-over-year comparison using the same number of days in #dax

    When you use the time intelligence functions in DAX, it is relatively easy to filter the same dates selection in the previous year by using the SAMEPERIODLASTYEAR or DATEADD functions. However, if you follow the best practices, it is likely that you have a full date table for the current year, which includes many days in the future. If you are in ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 24, 2017
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement