Topic: Tabular

        Page 26 of 258 posts
article –

Budget and Other Data at Different Granularities in PowerPivot

PowerPivot and BISM Tabular handle relationships between tables by using a single column that requires to be a unique column in the lookup table. In this article you will see how to handle relationships between tables that have different granularities,…  Read more

blog post –

String Comparison in #DAX

In DAX you don’t have the LIKE operator and you have to use SEARCH instead. However, performance are not very good and it is better to use LEFT and RIGHT if you just need to compare the initial (or ending) match of a string. I just wrote an article about  Read more

blog post –

Query Projection in #DAX

I wrote a short article about query projection in DAX. To make the story short, you should always use SUMMARIZE in order to remove columns from a table in a query. Thus, if you just want three columns from a table, instead of writing this in SQL: SELECT  Read more

blog post –

Sorting Dates Columns in #PowerPivot and #BISM #Tabular

I just published an article about Sorting Dates Columns in PowerPivot v2 and BISM Tabular on SQLBI website. In reality, the article is about sorting columns by other columns in a Tabular model, but the common scenario in which you need that is in a Calendar  Read more

blog post –

#DAX Query Plan in SQL Server 2012 #Tabular

The SQL Server Profiler provides you many information regarding the internal behavior of DAX queries sent to a BISM Tabular model. Similar to MDX, also in DAX there is a Formula Engine (FE) and a Storage Engine (SE). The SE is usually handled by Vertipaq  Read more

blog post –

PowerPivot, basket analysis and the hidden many to many

Surfing on the web, here , I came into this intriguing question: How do we ask something like “Show me how many customers have an iPad but don’t have a book?” We are speaking about a sales analysis where the canonical entities are Customers, Products  Read more