Using dates from two columns

[Dicko]

Hi all,

I've got three tables.

Please assume I cannot alter anything using Power Query in this case.

A facts table:

Dossiers

id_dossier

created_at

A dimensions table:

Dossiers_Timeline

id_dossier

opened_at

closed_at

A Date_Lookup table:

Date_Lookup

01-01-2021

02-02-2021

...

The Date_Lookup has a 1-to-many relationship with Dossiers.

As we see, the Dossiers_Timeline also has two date columns: opened_at and closed_at.

Also there are measures:

nr_of_rows_dossiers  = COUNTROWS(Dossiers)

nr_of_rows_timeline = COUNTROWS(Dossier_Timeline)

Now I want to make one Table Visual where I show the the created_at, opened_at and closed_at columns for each dossier.

Dossier ID

Created

Opened

Closed

How do I do this?

Thanks.

[parry2k]

@Dicko ask a question yourself if a Dossies has multiple timeline records which opened date and closed at date you would like to show when there are multiple records for the same dossier?

[parry2k]

@Dicko what is the relationship between dossier_timeline and dossier, it is 1 to 1 or 1 to many?

[Dicko]

The Dossiers table has a 1-to-many relationship with Dossiers_Timeline:

Thanks for your quick reply BTW!