Forum Discussion
anmarti3
6 years agoFrequent Visitor
Dynamic Table Calculation Based on User Input
Hi all,
I have a scenario where I need to have a column (or measure?) that calculates a DateDiff between an invoice due date and date input by a user to determine how many days past due is an invoice related to that user key date. For example given the sample data and a user keys in date 9/1/2019 they would get the Days Past Due column highlighted in red below. The Issue here is getting that key date to be used within the dashboard to interact with that table dynamically to deliver the results below. Any thoughts?
| Invoice | Due Date | Balance | Days Past Due |
| 1001 | 9/5/2019 | $40 | 4 |
| 1002 | 9/18/2019 | $80 | 17 |
| 1003 | 9/26/2019 | $100 | 25 |
Thanks!
Replies have been turned off for this discussion