Forum Discussion
Filtering Data on Order Date but Display Values based on Invoice Date in a Matrix
Hi everyone - looking for some help with filtering and displaying data with multiple dates. I recieve daily order data that includes 3 important pieces of information: Order Date - date the ord...
You can do this with two date tables. One tied to the order date and the other to invoice date. This is my preference but it does duplicate date tables. The other approach is to relate both dates to the date table. Then create measure that activates the inactive relationship with USERELATIONSHIP.