Forum Discussion
Filtering Dates Across Multiple Tables
Hello, I have an issue where the user has to select three dates from three different date slicers. One table is a customer invoice table, the next table is a customer payments table with a foreig...
Check out the USERELATIONSHIP function and see if it gets you there:
Here's my model. If I could trouble you for some recommendation(s) on what to use as inactive joins. The "PD Calendar" is used to calculate the days past due. The join from invoice to payment is on the primary key. The only active join insofar as dates, is from date to GL Date on the invoice table.
Current model . . .
