Use different Date dimension

[Boseca]

Hello Everybody. I having issues to provide a simple needs and maybe I'm doing something wrong.

I have a table of the order with 2 dates: Date Of Order and Date Of Delivery.

DATE OF ORDER	DATE OF DELIVERY	ORDER ID
1/1/2021	2/1/2021	A
1/1/2021	2/1/2021	B
2/1/2021	3/1/2021	C
2/1/2021	3/1/2021	D

I would like to have a chart like this:

DATE	NUMER OF ORDER	NUMBER OF DELIVERY
1/1/2021	2	0
2/1/2021	2	2
3/1/2021	0	2

Can you please kindly give me an idea how to solve easly?

Thank you very much for any help.

[Bastien_Laugiero · Accepted solution]

Hi, 

Please find attached QVF with an example based on your data. 

Idea is to create a link table in your script with a common date field. 

Some interesting reading about this topic: 

• Linking to two or more dates
• Canonical Date

Hope this helps!

[Boseca]

Thank you very much! It work like a charm.