I’ve developed a Power BI model containing an Invoice table. Customers can settle their bills through equal monthly instalments. The table includes a column indicating the number of approved instalments (monthly installment amount is total amount divided by the number of instalments). Now, I’d like to display the projected future income based on upcoming instalments due for collection. To achieve this, I’ve set up a Date table using the next DAX code: