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 amo...
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
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