Selected Tags:

dax, design
Available Tags: article, basket, date, excel, many-to-many, mdx, parent-child, tabular, time, v2, video
Title Author Date
Simple Basket Analysis in DAX Chris Webb 10/21/2010
PowerPivot Time Calculations Teo Lachev 01/18/2011
Campaign Analysis: Seasonally-Adjusted Measures Rob Collie 01/19/2011
Working days computation in PowerPivot Alberto Ferrari 01/19/2011
PowerPivot and the Slowly Changing Dimensions Alberto Ferrari 02/09/2011
Date and Date/Time - Sneaky Data Types! Rob Collie 02/27/2011
PowerPivot, Parent/Child and Unary Operators Alberto Ferrari 03/01/2011
PowerPivot Nested Set Measures Goban Saor 03/11/2011
The problem of power users, DAX and difficult calculations Chris Webb 06/06/2011
The Great Precedence Project (Filter Rules for DAX) Rob Collie 06/14/2011
Running Totals Without a Traditional Calendar Table Rob Collie 07/05/2011
Quartile, Percentile and Median in PowerPivot Javier Guillen 07/12/2011
PowerPivot V2 CTP3! Rob Collie 07/12/2011
DAX Queries, Part 1 Chris Webb 07/15/2011
DAX Queries, Part 2 Chris Webb 07/15/2011
PowerPivot Denali: Working with multiple relationships between two tables Kasper de Jonge 07/15/2011
Tips and Tricks: Mapping Data to the World in a PowerPivot Workbook Kay Unkroth 08/16/2011
PowerPivot DAX: Find and Search in Denali Kasper de Jonge 08/16/2011
PowerPivot DAX PARALLELPERIOD vs DATEADD Kasper de Jonge 08/16/2011
Separate date and time in #powerpivot (and #bism tabular) Marco Russo 09/01/2011
Video - Many-to-Many Relationships in DAX Alberto Ferrari 11/21/2011
SQL UNPIVOT Makes My Data Skinny David Churchward 11/29/2011
The Greatest Formula in the World Rob Collie 12/06/2011
Prepayments and Deferred Revenue David Churchward 01/24/2012
Tracking Performance After an Event or Treatment Rob Collie 02/03/2012
Basic date handling in DAX Cathy Dumas 02/03/2012
Can EARLIER be used in DAX measures? Javier Guillen 02/06/2012
Lookups based on date ranges Rob Collie 02/07/2012
Handling SCD2 Dimensions and Facts with PowerPivot Gerhard Brueckl 02/16/2012
Detecting Total, Subtotal and Hierarchy Levels in PowerPivot Javier Guillen 02/20/2012
Correlating "Fuzzy Time" Events in One Table with Precise Measurements in Another Table Rob Collie 02/28/2012
Handling SCD2 snowflake-schemas with PowerPivot Gerhard Brueckl 03/01/2012
USERELATIONSHIP and direction of context propagation Javier Guillen 03/05/2012
What-if analysis using the right level of granularity in PowerPivot Javier Guillen 04/22/2012
ISO 8601 Week in DAX Gerhard Brueckl 04/22/2012
Clever Hierarchy Handling in DAX Alberto Ferrari 04/30/2012
Resolving Many to Many relationships leveraging DAX Cross Table Filtering Gerhard Brueckl 05/13/2012
Controlling the Position of Subtotals in DAX with GenerateAll() Chris Webb 05/16/2012
 

Varigence Vivid