Browse by Tags

• Analysis Services
• BIDS
• BISM
• Book
• Business Intelligence
• Communities
• Conference
• Conference Communities
• CTP3
• Denali
• Excel
• Excel 2013
• Gemini
• M2M
• MDX
• PASS
• PivotTable
• PowePivot
• Power View
• PowerPivot
• Reporting Services
• SSAS
• Tabular
• TechEd
• UDM

• Difference between LASTDATE and MAX for semi-additive measures in #DAX

  I recently wrote an article on SQLBI about the semi-additive measures in DAX . I included the formulas common calculations and there is an interesting point that worth a longer digression: the difference between LASTDATE and MAX (which is similar to FIRSTDATE Read More... Posted Tuesday, October 22, 2013 3:22 PM by Marco Russo (SQLBI) | 3 Comments Filed under: PowerPivot, DAX, Tabular

• Using USERELATIONSHIP function in Measures and Calculated Columns #dax #powerpivot #ssas

  You can use the USERELATIONSHIP function in DAX to apply a non-active relationship in a particular DAX calculation. This approach is usually simple in a measure (just use USERELATIOSHIP in one of the filter arguments of CALCULATE) but as soon as you try Read More... Posted Tuesday, October 01, 2013 2:25 PM by Marco Russo (SQLBI) | 4 Comments Filed under: SSAS, Analysis Services, DAX, Tabular

• Handling Wrong or Missing Dates in Tabular and #powerpivot #dax

  Recently I received a request from a reader related to the handling of missing or invalid dates in Tabular (but the same can be applied to Power Pivot). In the Analysis Services Tabular book , we wrote that you can insert a special row in the Date table Read More... Posted Tuesday, September 24, 2013 3:36 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, PowerPivot, DAX, Tabular

• Calculating First and Second Year of Sales by Customer in #dax #powerpivot #ssas #tabular

  I recently wrote an article that describes how to calculate a measure (such a sales, but it could be anything else) considering for each customer its first 12 months, then months 13-24 and so on. In practice, for every customer you have a different range Read More... Posted Monday, September 09, 2013 3:33 PM by Marco Russo (SQLBI) | 0 Comments Filed under: PowerPivot, DAX, Tabular

• Time Intelligence Video Tutorial on Project Botticelli #dax #powerpivot #ssas

  Alberto Ferrari recently recorded a free short video introduction about what is time intelligence . When you have to perform time-related calculations in Power Pivot or in Analysis Services Tabular, you have to rely on some DAX expressions. There are Read More... Posted Thursday, September 05, 2013 3:36 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, Analysis Services, PowerPivot, DAX, Tabular

• Dynamic Calculation of Inventory with #dax in #powerpivot and #ssas #tabular

  I recently wrote an article on SQLBI describing the dynamic calculation of stock inventory in DAX. With this technique, you can avoid creating a snapshot fact table just to store the inventory stock for every day and every product, creating a table that Read More... Posted Tuesday, August 27, 2013 3:18 PM by Marco Russo (SQLBI) | 2 Comments Filed under: SSAS, PowerPivot, DAX, Tabular, Excel 2013

• Understanding #DAX Query Plans for #powerpivot and #tabular

  Alberto Ferrari wrote a very interesting white paper about DAX query plans. We published it on a page where we'll gather articles and tools about DAX query plans: http://www.sqlbi.com/topics/query-plans/ I reviewed the paper and this is the result of Read More... Posted Monday, July 22, 2013 4:06 PM by Marco Russo (SQLBI) | 2 Comments Filed under: SSAS, PowerPivot, DAX, Tabular

• From 0 to DAX at TechEd Pre-Conference Seminar #dax #msteched #tee13

  In June I and Alberto will deliver a pre-conference seminar at both TechEd North America (New Orleans, LA) and TechEd Europe (Madrid, Spain). This day is a very good quickstart for those of you that still didn't complete one of our books , or those of Read More... Posted Tuesday, May 07, 2013 3:54 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, DAX, PowePivot, Tabular

• Group Sales by Age of Customers #dax #powerpivot #tabular

  I published an article describing how to implement the grouping of sales transactions by age of customer at the moment of the transaction by using PowerPivot or Analysis Services. The same pattern can be used also for any kind of banding operation, this Read More... Posted Monday, May 06, 2013 3:16 PM by Marco Russo (SQLBI) | 4 Comments Filed under: PowerPivot, DAX, Tabular

• DAX Studio for Excel 2013 finally available! #dax #excel #powerpivot #ssas #tabular

  I'm so happy that DAX Studio finally supports Excel 2013! As Darren Gosbell described in his blog , this release has a few internal changes that will better support future enhancements. I will port the code to capture the query plan for a query in this Read More... Posted Saturday, May 04, 2013 8:49 AM by Marco Russo (SQLBI) | 2 Comments Filed under: SSAS, Excel, PowerPivot, DAX, Tabular, Excel 2013

• Advanced DAX course in May - unique date in 1H 2013 #dax #tabular #ssas #powerpivot

  One year after the release of SQL Server 2012 I see the growing demand for DAX. There are two reasons for that: an higher number of PowerPivot users started to build more complex data models, and SSAS Tabular is starting to be adopted by a larger number Read More... Posted Monday, April 22, 2013 11:55 AM by Marco Russo (SQLBI) | 3 Comments Filed under: SSAS, Analysis Services, DAX, PowePivot, Tabular

• LASTNONBLANK and FIRSTNONBLANK functions work with any column #dax #powerpivot #ssas #tabular

  During a PowerPivot Workshop course we received an interesting question from a student: “Can I use LASTNONBLANK (and FIRSTNONBLANK) with a column which is not a date column?” The reason is that we introduce LASTNONBLANK in the Advanced Time Intelligence Read More... Posted Friday, April 19, 2013 1:28 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, Excel, PowerPivot, DAX, Tabular

• SQLLunch on April 23 in London and Cardiff #sqlpass #dax #sqllunch

  On April 23 I will present DAX in Action in London and Cardiff at SQLLunch event. How is it possible I will be in two places at the same time? This will be a remote presentation delivered in two locations, where you can have lunch while watching the session. Read More... Posted Monday, April 15, 2013 11:52 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Communities, MDX, DAX, Tabular

• Pre-Conference Seminar about DAX at TechEd 2013 #msteched #dax #ssas

  If you are using Microsoft BI stack and you still didn’t start learning DAX, you should not wait any longer. One of the option you have is starting with one of our books , or you can also attend one of our workshop about Tabular or PowerPivot . But if Read More... Posted Thursday, March 14, 2013 3:24 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Conference, Analysis Services, DAX, TechEd

• Querying with DAX video available on Project Botticelli #dax #ssas #powerpivot

  I recently published a video session on Project Botticelli web site regarding querying in DAX. You can write DAX queries to extract data from both PowerPivot and SSAS Tabular models. This could be particularly useful in three scenarios: Reports in Reporting Read More... Posted Monday, February 25, 2013 3:39 PM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, PowePivot, Tabular