-
as seen on SQL Blog
- Search for 'SQL Blog'
If you started using DAX as a query language, you might have encountered some performance issues by using SUMMARIZE. The problem is related to the calculation you put in the SUMMARIZE, by adding what are called extension columns, which compute their value within a filter context defined by the rows…
>>> More
-
as seen on SQL Blog
- Search for 'SQL Blog'
The DATE function in DAX has this simple syntax: DATE( <year>, <month>, <day> ) If you are like me, you never read the BOL notes that says in a clear way that it supports dates beginning with March 1, 1900. In fact, I was wrongly assuming that it would have supported any date that…
>>> More
-
as seen on SQL Server Central
- Search for 'SQL Server Central'
Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series…
>>> More
-
as seen on SQL Server Central
- Search for 'SQL Server Central'
Bill Pearson, Business Intelligence architect and author, exposes the DAX DISTINCT() function, and then provides some hands-on exposure to its use in generating distinct counts. Moreover, he further explores working with measures in the PivotTable in this, the third Level of our new Stairway to PowerPivot…
>>> More
-
as seen on SQL Server Central
- Search for 'SQL Server Central'
Business Intelligence architect and author Bill Pearson exposes the DAX BLANK() function, and then provides some hands-on exposure to its use in managing empty values underlying our PowerPivot model designs.
Save 45% on our top SQL Server database administration tools. Together…
>>> More
-
as seen on SQL Blog
- Search for 'SQL Blog'
Short version: the latest available version of MDX Studio can be downloaded from http://www.sqlbi.com/tools/mdx-studio/ Long version: Last week Stacia Misner twitted that the online version of MDX Studio was no longer available. It was hosted on http://mdx.mosha.com. It was a sad news, and it is…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Why aren't my results being filtered by the members from my [Group Hierarchy] returned via the filter() statment below?
SELECT
NON EMPTY {[Measures].[Group Count], [Measures].[Overall Group Count] } ON COLUMNS,
NON EMPTY {
[Survey].[Surveys By Year].[Survey Year].ALLMEMBERS…
>>> More
-
as seen on SQL Server Central
- Search for 'SQL Server Central'
To learn MDX, there is really no alternative to installing the system and trying out the statements, and experimenting. William Pearson, the well-known expert on MDX, kicks off a stairway series on this important topic by getting you running from a standing start.
NEW! SQL…
>>> More
-
as seen on SQL Blog
- Search for 'SQL Blog'
I just published the article Converting MDX to DAX – First Steps on the renewed SQLBI web site about converting MDX to DAX. The reason is that with BISM Tabular in Analysis Services 2012 you will be able to write queries in both DAX and MDX. If you already know MDX, you might wonder how to “translate”…
>>> More
-
as seen on SQL Blog
- Search for 'SQL Blog'
Jeffrey Wang wrote a great blog post about attribute overwriting in MDX that is very clear and full of helpful pictures to show what happens when you write an MDX statement that writes into your multidimensional space. This is very common in an MDX Script and if you tried to customize the DateTool…
>>> More
