When I first started to play with DAX, one of the functions that seemed to confuse me more than it should, was how to add ranking to my data. It didn’t seem to matter what the data was, if I followed the online documentation sometimes it would work, while other times the function would return …
Quality testing is one of those things that few of us enjoy but is vital to maintaining the trust of people who consume our reports. One of my former bosses, who was a former McKinsey consulting that I worked with during my MBA internship, taught me many valuable lessons about Excel and financial modeling. …
The SQL language offers the following types of JOIN:
The result of a JOIN does not depends on the presence of a relationship in the data model. You can use any column of a table in a JOIN condition.
In DAX there are two ways you can obtain a JOIN behavior. First, you can …
In Analysis Services, almost every object and workload is programmable, and often there is more than one approach to choose from. Options include writing managed code, script, or using open standards like XMLA and MSOLAP if your solution requirements preclude using the .NET framework.
What you can accomplish in code
Typical programming scenarios include server and database …
What you learn
How to create a new tabular model project at the 1400 compatibility level in Visual Studio with SSDT.
How to import data from a relational database into a tabular model project workspace database.
How to create and manage relationships between tables in the model.
How to create calculated columns, measures, and Key Performance Indicators that help …