Topic: DAX

Page 20 of 213 results
  • Whenever you have to calculate the distance between two dates, you can simply subtract two dates and DAX in PowerPivot will give you the answer. However, in case you want to calculate the difference in terms of working days you have to instruct your data  Read more

  • Jeffrey Wang wrote a new post about DAX Time Intelligence functions. This is an “under the cover” description that explains the rationale behind these functions, which need to be used following particular guidelines (described at the beginning of the  Read more

  • Alberto Ferrari wrote an interesting post about a “different approach” in creating a ranking measure with PowerPivot . If you know DAX or you read our book , you will find that a DAX expression can solve the issue. However, such a formula is more complex  Read more

  • If you have not been at Microsoft Business Intelligence Conference this year, which was co-located with TechEd 2010, you probably missed the sessions I and Alberto made there. Well, now you can watch them online on Microsoft TechEd Online site: DAX Patterns  Read more

  • Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it  Read more

  • Alberto wrote a really fine post that should help you to better understand how many-to-many relationships can work in PowerPivot, using a lot of images that explain some concepts better than a thousand words. The example shown by Alberto is really interesting  Read more

  • I will be a speaker this year at PASS Summit 2010 in Seattle, and I will present two sessions. The one I’d like to talk about in this post is the Inside DAX one. I chose to do this session (instead of another one that was initially planned) because when  Read more

  • Alberto Ferrari posted an interesting article that show how you can use a continuous value in a group of values in PowerPivot. I think this is a feature that many users would like to get in a standard Analysis Services cube, but that unfortunately requires  Read more

Show more