How to use copy date column to other table?

[Camstr]

Hello,

I have the following simplified model.  I have two fact tables that I want to filter, using slicers, by 'Site' and 'Date Time'.  'Date Time' column in red does not currently exist.

• I want to avoid creating a 'Date Time' measure as I want to use it in a Slicer.
• I want to avoid bidirectional filter direction to avoid later ambuiguity.
• I want to avoid many-many cardinality between two fact tables.

How do I 'get' a 'Date Time' column into the 'Jobs' table that allows me to slice between both fact tables in the same report (sync'd slicers).

Thank you

[Camstr]

Thanks @Anonymous !

[Anonymous · Accepted solution]

Hi, @Camstr 

Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display. After creating a new table using Summarize, then rejoin the relationship.

Measure:

New Jobs Table =

SUMMARIZE(

    NATURALINNERJOIN('Jobs', 'Daily Summary(Daily)'),

    'Jobs'[Activity ID],

    'Jobs'[Site],

    'Daily Summary(Daily)'[Start Date Time]

)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum