THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » DAX » PowerPivot   (RSS)
Showing page 2 of 9 (84 total posts)
  • Customize period comparison in DAX #powerpivot #dax #powerbi

    I have seen many different types of custom calendars implemented in Power Pivot, Tabular, and DAX. I also wrote several articles (week based calendars and time patterns). However, there is a scenario that is hard to manage with the classical approaches, which I discussed in a new article. Suppose you want to implement custom comparisons. For ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 5, 2015
  • Dynamic ABC Classification in DAX #powerpivot #dax #ssas #tabular

    Less than one year ago I published a pattern about ABC Classification in DAX. Such a pattern was static, so an item (e.g. customer, product) is classified statically when you process a Power Pivot or Tabular model, so filters and slicers querying data do not affect the classification’s results. In the following weeks I discussed with Alberto ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 22, 2015
  • DAX Patterns 2015 book available now #daxpatterns #dax

    In 2014 we published several articles in the DAX Patterns web site. We’ll continue to publish new patterns in 2015 (the first one later this month!), but in the meantime we created a first printed version of the patterns available: DAX Patterns 2015. It might seem strange, but we really received several requests for a book version of the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 8, 2015
  • DAX Studio 2.0 finally available! #dax #ssas #tabular #powerpivot

    Darren Gosbell announced on his blog that DAX Studio 2.0 is available. This new release has a completely new user interface, a renewed architecture and also work as a standalone executable without Excel. Yes, you read it right. You can use DAX Studio on a server without having to run it in Excel. You can now connect with Remote Desktop to your ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 8, 2014
  • What are useful tools and resources for DAX developers? #dax #powerpivot #tabular

    At the last PASS Summit I received an interesting question: is there a list of all the useful (I would say necessary…) tools for DAX developers? My answer was… “no, but this is an interesting topic for a blog post”. In the meantime, I thought that a page to keep updated would have been better, and of course an easy-to-remember URL is equally ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 20, 2014
  • Don’t use SUMMARIZE to sum your data–or just be careful #dax #ssas #powerpivot

    During the last PASS Summit I and Alberto Ferrari had long discussions at SQL Clinic with some of the developers of our loved tools. Sometime you really have to dig in the internals of certain feature to understand why there are some “unexpected” behaviors for certain functions. One of the discussions was about SUMMARIZE. This function can be very ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 18, 2014
  • A strange behavior of AutoExist for MDX on Tabular models #powerpivot #ssas #tabular

    Alberto Ferrari wrote an interesting article about a strange behavior of AutoExist in normalized data models. I always say that a star schema is the best practice in Power Pivot and Tabular data modeling. The issue described by Alberto is another good reason to avoid snowflake schemas. I think that an example is better than many words. Consider ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 21, 2014
  • Simulate the SQL WHERE condition in DAX–#dax #powerpivot #ssas

    I recently wrote a short article about filtering data in DAX. In the last month I’ve seen a growing number of people with a SQL background going to Tabular, without having a previous experience of MDX. In my opinion, learning DAX is easier if you try to match its features to SQL rather than to MDX. The reality is that DAX is somewhere in the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 29, 2014
  • Possible SWITCH Optimization in DAX – #powerpivot #dax #tabular

    In one of the Advanced DAX Workshop I taught this year, I had an interesting discussion about how to optimize a SWITCH statement (which could be frequently used checking a slicer, like in the Parameter Table pattern). Let’s start with the problem. What happen when you have such a statement? Sales :=     SWITCH ( ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 18, 2014
  • DIVIDE vs division operator in #dax

    Alberto Ferrari wrote an interesting article about DIVIDE performance in DAX. This new function has been introduced in SQL Server Analysis Services 2012 SP1, so it is available also in Excel 2013 (which still doesn’t have other features/fixes introduced by following Cumulative Updates…). The idea that instead of writing: IF ( Sales[Quantity] ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 24, 2014
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement