|
|
|
|
SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus
Browse by Tags
All Tags » Tabular » DAX (RSS)
-
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...
|
-
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...
|
-
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...
|
-
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...
|
-
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...
|
-
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...
|
-
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...
|
-
I and Alberto Ferrari will speak at SQLBits XI (Nottingham, UK – May 2-4, 2013) and there are many good reasons to join us there, especially if you are interested to DAX! Here are our sessions: Thursday, 02 May 2013 – Training Day - From 0 to DAX The Read More...
|
-
DAX offers a set of Time Intelligence functions that simplify writing DAX expressions such as YTD, YOY and other time-related calculations. However, these functions only works when some assumptions are valid: your periods should be “natural” months and Read More...
|
-
Are you working with SSAS Tabular? Are you an experienced PowerPivot user? In both cases, you should be aware that there is only one skill that is important for PowerPivot and SSAS Tabular, and it is the DAX language. I and Alberto have been using DAX Read More...
|
-
Apparently Excel does not offer a way to import data in Excel by using a DAX query on Analysis Services. The Data Connection Wizard seems to offers only the ability to create a PivotTable when you connect to Tabular, but not a Table (see the Table option Read More...
|
-
This year is going to end, Maya failed their predictions and while this is bad for predictive industry, it’s also good for all of us! We’ve seen many news in Microsoft BI stack: Excel 2013 has been RTM’d – its General Availability is expected in early Read More...
|
-
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 Read More...
|
-
Next week I and Alberto Ferrari will be in Seattle at PASS Summit 2012 . You can meet us at our sessions, at a book signing and hopefully watching some other session during the conference. Here are our appointments: Thursday, November 08, 2012, 10:15 Read More...
|
-
I recently published a set of rules for DAX code formatting . The following is an example of what I obtain: CALCULATE ( SUMX ( Orders, Orders[Amount] ), FILTER ( ALL ( Customers ), CALCULATE ( COUNTROWS ( Sales ), ALL ( Calendar[Date] ) ) > 42 + 8 Read More...
|
|
|
|
|
|