Handling Wrong or Missing Dates in Tabular

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

In the traditional star schema design of a Data Mart, you replace a missing, unknown or wrong date in the fact table with a dummy value in the Date dimension table. In Tabular, handling a Date table requires an existing date and you cannot use a NULL date in a Date table. This article describes how to apply the NULL replacement in the fact table using views, without altering the relational structure of the Data Mart.

Read more...

Tags: dax, design

 

2007-2015 VidasSoft Systems Inc.