Blogs from Wise Owl on Calculated columns in SSAS tabular

Showing blogs 1-3 (out of 3)

How to use the EARLIER function in DAX to sort, group, band and accumulate data

Posted by Andy Brown on 13 January 2016

Although the EARLIER function in DAX is complicated, it's also very useful! This blog shows how the function works, and how to use it to create running totals, sort rows, create group statistics and divide data into bands.

Using the RELATED function to link tables, and how to test for blanks in DAX

Posted by Andy Brown on 05 January 2016

You can make pivot tables much easier to use by combining all of the aggregator columns into a single table, using the RELATED function. This blog also shows you how to work with blanks, including using the ISBLANK function to test whether matching values exist in linked tables.

Learn how to create calculated columns in a tabular model using DAX

Posted by Andy Brown on 05 January 2016

Creating calculated columns in tabular models is deceptively similar to creating formulae in Excel. Deceptively, because the underlying language (DAX) is completely different, and you can make use of functions like SWITCH which have no Excel equivalent. This blog shows what calculated columns are, and how to create them.

This page has 0 threads Add post