can you please help me with this issue I have? Currently, I have two tables, one for date and another for customer transactions. And I want to have a column where it will show the age of my receivables. Last date in my date table is 12/31/2025 and in my date difference, my due date computes against 12/31/2025. What should I do to make it so that the difference will be from the selected value in my slicer?
relationship on the date and customer transactions is the Posting Date from customer transactions.
If measure is the only way for classification of current, 1-30 days due, 31-60 days dues, etc. what can be the way to make the classification be the axis in my stacked bar chart?
I don't 100% understand your requirement. You want to calculate the difference between which two dates? The date slicer selects dates between 1/1/2018 and 3/26/2021, and the table shows Due Date is 3/25/2021. Is there a connection between them? And you want the difference between 3/26/2021 and 12/31/2025? Or I totally understand it wrong? Can you describe the output with some sample data to help us understand your requirement better?