Line chart between two dates

Hi,

I don't really understand what do you mean by

However, the start and end of the line should be based on the PurchaseDate and PaymentDate columns.

---

These are two independent events and I believe you do have different dates in your real data (as you have in the sample data)

05/02/2024;05/11/2024;Wireless Headphones;Credit;-450;15850;5

If what I assume is correct then you might have two options:

1. Create two measures, one based on Purchase Date and the other on Payment Date and plot them in a line chart based on the dimDate[Date] date. You already have a relationship between [Date] and Purchase Date so you need to create the 2nd relationship. This relationship will be inactive but you can activate it when creating the measure for Payment Date by using USERELATIONSHIP at the end of your calculation.

2. Create an Outstanding Debts only if the Payment Date differs from Purchase Date (see below):

Outstanding Debt 2 = CALCULATE(
SUM(Installment_BankStatement[Amount]),
Installment_BankStatement[PaymentMethod] = "Credit", 
Installment_BankStatement[PurchaseDate] >= MIN(dimCalendar[Date]),
Installment_BankStatement[PurchaseDate]<>Installment_BankStatement[PaymentDate])

The do the Accounts Payable with the above measure, then plot it using the dimDate[Date].

If this answered your question please mark it as the solution.

Best,