How create Month end evolution logic

Hi eryka_90  

First you have to create Calender table. The you have to link this Calender table to vendor table by using Posting date 

Then Calculate Ageing bins 

Ageing Bins = 
VAR DueDate = 'Vendor'[Net Due Date]
VAR LastDayOfMonth = EOMONTH(DueDate, 0)
VAR DaysDifference = DATEDIFF(DueDate, LastDayOfMonth, DAY)
RETURN
    SWITCH(TRUE(),
        DaysDifference <= 0, "Not Due",
        DaysDifference <= 5, "0-5 Days",
        DaysDifference <= 15, "6-15 Days",
        DaysDifference <= 30, "16-30 Days",
        "Over 30 Days"
    )

After this create Open Invoice mesure  

Open Invoices = 
CALCULATE(COUNTROWS('Vendor'),
    FILTER('Vendor',
        'Vendor'[Posting Date] < DATE(2024, 2, 1) &&
        'Vendor'[Clearing Date] > DATE(2024, 1, 31)))

After this create Debit balance measure 

Debit Balance = 
CALCULATE(SUM('Vendor'[Debit Balance]),
    FILTER('Vendor',
        'Vendor'[Posting Date] < DATE(2024, 2, 1) &&
        'Vendor'[Clearing Date] > DATE(2024, 1, 31))
)

The take Matrix chart and drag month column from calender table in to rows, drag Ageing Bins column into columns and last but not least drag Open Invocie and Debit balance into values.

Let me Know if it works...