Forum Discussion
Link Calendar
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
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.
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
2 Replies
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.
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