Report Portal

Handling Wrong or Missing Dates in Tabular

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.


Tags: design, dax, tabular


2007-2015 VidasSoft Systems Inc.