Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
5 years ago

Using two date tables. Marking as date tables?

We have two dates that are of equal importancein in the dataset. We decided to have two date tables with active joins to each table so we dont have to USERELATIONSHIP in the DAX for the none active relationship

 

However, we just realised that we can only mark one of the tables as a date table?

 

That leaves us with a problem. We want them both to be Date tables so DAX will understand that all the data in the table are related to dates.

 

But we can only have one table marked as a date table?

 

How do we get round this issue? To me this almost means that the solutions Ive been seeing about multiple date tables cant actually be a proper viable option?

 

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    there's no need to mark more than one of them as a Dates table.  The sole purpose of the marking is to prevent Power BI from creating its own internal date hierarchies on the date columns.  Time intelligence functions will still work with a table that is not marked as a Dates table, the important thing is that the table is contiguous.