table with more than one date column

Hi miinseon ,

Your solution is great, bhanu_gautam . Here I have another idea in mind, and I would like to share it for reference.

As per your question, I have created simple data :

Since you need to get the amount paid one day after the reserve date, we use the following function:

Measure 2 =

VAR _date = SELECTEDVALUE('DAX DateTable'[Date]) + 1

VAR _sum = CALCULATE(SUM('Table'[price]),FILTER(ALL('Table'),'Table'[payment_date] = _date && 'Table'[reserve_date] = SELECTEDVALUE('DAX DateTable'[Date])))

RETURN

_sum

The final results are as follows:

If you have any other questions please feel free to contact me.

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!