Link Calendar

[Anonymous]

Hi all,

I want to link 2 calendars to the same filter.

I have a table invoice. Containing all the invoices and it has an invoice date.

It also contains a shipment date

And it contains an amount

for example

invoice1

Shipment: 1/1/2018 

Invoicedate: 3/1/2018

Amount: 100

Invoice2

Shipment: 2/1/2018 

Invoicedate: 3/1/2018

Amount: 100

Invoice3

Shipment: 3/1/2018 

Invoicedate: 4/1/2018

Amount: 100

I created one date table using dax. DateFilterTable = Autocalendar()

But I can't connect this table to both fields as a relation

So I switched to 2 date tables instead of DateFilterTable

Called shipmentdatefilter and invoicedatefilter

Now I need to create a graph wich visualize the folowing

Over a period of time the amount shiped on that day and the amount invoiced that day.

Should be something like

1/1/2018

Shipped: 100

Invoiced: 0

2/1/2018

Shipped: 100

Invoiced: 0

3/1/2018

Shipped: 100

Invoiced: 200

4/1/2018

Shipped: 0

Invoiced: 100 

How to do this.
Of even if they are in 2 different graphs. I can pull this of.. But I need to add a slicer for both calendar tables. And If I change one the other one is not changed with it. So I need to set both filters manually.

PS. This is, of course, a fictive but simple example of the issue

Kind regards

[gooranga1 · Accepted solution]

Hi @Anonymous,

I would generate 2 tables one called Invoice the other called shipment.  I would just copy your Invoice table that you have and call ti shipments. Then join those 2 tables to 1 date dimension on invoice date and shipment date respectively.

You can then generate the graph you want useing the date dimension.

[jthomson · Accepted solution]

You can connect multiple date fields to a date table, you just need to make sure that you use USERELATIONSHIP in the measures etc that involve whichever date field(s) are inactive

[gooranga1 · Accepted solution]

Hi @Anonymous,

I would generate 2 tables one called Invoice the other called shipment.  I would just copy your Invoice table that you have and call ti shipments. Then join those 2 tables to 1 date dimension on invoice date and shipment date respectively.

You can then generate the graph you want useing the date dimension.