Dynamic Table Calculation Based on User Input

anmarti3 — Wed, 25 Sep 2019 18:46:55 GMT

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!

topic Dynamic Table Calculation Based on User Input in Developer

Dynamic Table Calculation Based on User Input