Browse by Tags

• Analysis Services
• BIDS
• BISM
• Book
• Business Intelligence
• Communities
• Conference
• Conference Communities
• CTP3
• Data Mining
• Denali
• Distinct
• Excel
• Excel 2013
• Gemini
• LINQ
• M2M
• May
• MDX
• PASS
• PivotTable
• PowePivot
• Power BI
• Power Query
• Power View
• PowerPivot
• Reporting Services
• SQL Server 2012
• SQL Server 2016
• SSAS
• Tabular
• TechEd
• UDM
• Visuals

• The easiest way to start using variables in #dax

  I just published a new blog post on SQLBI. You can read it at this link: http://www.sqlbi.com/blog/marco/2017/09/12/the-easiest-way-to-start-using-variables-in-dax/ Read More... Posted Tuesday, September 12, 2017 2:25 PM by Marco Russo (SQLBI) | 2 Comments Filed under: DAX, Power BI

• Local #dax measures in #powerbi reports are not visible from #Excel

  I just published a new blog post on SQLBI. You can read it at this link: http://www.sqlbi.com/blog/marco/2017/08/28/local-dax-measures-in-powerbi-reports-are-not-visible-from-excel/ Read More... Posted Monday, August 28, 2017 3:53 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Excel, DAX, Power BI

• New function and the importance of variables in DAX #dax

  I recently wrote a few articles about a new function in DAX and the use of variables. For those of you using Power BI or Azure Analysis Services, you always have access to the latest version of the language. Well, in reality I see that new features appears Read More... Posted Tuesday, August 1, 2017 12:39 PM by Marco Russo (SQLBI) | 2 Comments Filed under: SSAS, DAX, PowePivot, Tabular, Power BI

• User group meetings and #dax training in Minneapolis and Chicago

  In the next three weeks I will deliver many speeches and training in United States. Here is the list: June 11, 2017 : Precon Data Modeling with Power BI at Microsoft Data Insights Summit (Seattle, WA) June 12, 2017 : Workshop DAX 101 at Microsoft Data Read More... Posted Wednesday, June 7, 2017 2:31 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Conference Communities, Conference, SSAS, DAX, Tabular, Power BI

• 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 Read More... Posted Tuesday, May 2, 2017 8:12 AM by Marco Russo (SQLBI) | 4 Comments Filed under: Analysis Services, DAX, PowePivot, Power BI

• 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 Read More... Posted Tuesday, March 21, 2017 3:34 PM by Marco Russo (SQLBI) | 0 Comments Filed under: PowerPivot, DAX, Power BI

• 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, Read More... Posted Tuesday, March 7, 2017 11:50 AM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, DAX, Tabular, Power BI

• 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 Read More... Posted Wednesday, February 22, 2017 3:27 AM by Marco Russo (SQLBI) | 9 Comments Filed under: DAX, Power BI

• 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 Read More... Posted Thursday, February 2, 2017 2:45 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, DAX, Power BI

• 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 Read More... Posted Tuesday, January 24, 2017 1:50 PM by Marco Russo (SQLBI) | 3 Comments Filed under: SSAS, DAX, PowePivot, Tabular, Power BI

• VertiPaq Analyzer 1.7: a fundamental tool for #powerbi #powerpivot #ssas #tabular diagnostics and documentation

  If you work with Power Pivot, Power BI, or Analysis Services Tabular, you probably already know VertiPaq Analyzer. If you never used it, with the new release 1.7 you have another couple of very good reason to try it. VertiPaq Analyzer is a Power Pivot Read More... Posted Monday, January 16, 2017 2:34 PM by Marco Russo (SQLBI) | 5 Comments Filed under: SSAS, Analysis Services, PowerPivot, DAX, Tabular, Power BI

• Santa Claus brings presents to #dax, #powerbi, and #ssas #tabular users

  If you think that the end of the year would have been a quiet time because the Power BI team will skip their monthly release (but are we sure?), you might be reassured (or disappointed depending on your perspective) looking at the news I have in this Read More... Posted Wednesday, December 21, 2016 3:58 PM by Marco Russo (SQLBI) | 2 Comments Filed under: SSAS, DAX, Tabular, Power BI, Visuals

• Format measures as dates in Power BI #dax #powerbi

  If you want to format a measure as date in Power BI, you need an expression returning a date/time data type. This is different from what you can do in Power Pivot and in SSAS Tabular, where you can format any numeric expression using a date and/or time Read More... Posted Tuesday, December 6, 2016 9:14 AM by Marco Russo (SQLBI) | 5 Comments Filed under: DAX, Power BI

• DAX Editor 2.0 finally available: it is a must have for #ssas #tabular #dax developers

  The SQL Server Data Tools (SSDT) editor for Tabular models has been improved in the recent updates. For example, the Tabular Model Explorer enables you to quickly jump between the entities of your model organized in a hierarchical way. However, when it Read More... Posted Monday, November 21, 2016 2:15 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, DAX, Tabular

• Analyze multiple EVALUATE statement in a single #dax statements in DAX Studio

  A few hours ago, DAX Studio 2.5.0 has been released, with a number of small new features (I will write about DirectQuery and new column in Server Timings in a future blog post and article). In the many bug fixes, this version of DAX Studio does not raise Read More... Posted Thursday, October 20, 2016 11:56 AM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, Tabular