Time intelligence - Show dates with no data on date axis

Hi Nilsstigel ,

Please refer to my pbix file to see if it helps you.

Create a new table.

Months =
DISTINCT (
    SELECTCOLUMNS (
        CALENDARAUTO (),
        "MonthNo.", MONTH ( [Date] ),
        "Month", FORMAT ( [Date], "MMM" )
    )
)

Then create a measure.

Measure =
CALCULATE (
    SUM ( 'Table'[NumberofVacancies] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        SELECTEDVALUE ( Months[MonthNo.] ) >= MONTH ( 'Table'[RegistrationDate] )
            && SELECTEDVALUE ( Months[MonthNo.] ) <= MONTH ( 'Table'[ApplicationDeadline] )
    )
)

Or a column.

column =
CALCULATE (
    SUM ( 'Table'[NumberofVacancies] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        Months[MonthNo.] >= MONTH ( 'Table'[RegistrationDate] )
            && Months[MonthNo.] <= MONTH ( 'Table'[ApplicationDeadline] )
    )
)

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.