calender table

[Anonymous]

when I'm trying to create a calendar table
calender = calendar (MIN(project [contract start date],(MAX(project [contractenddate])..it is showing contract end date has some blank values,unable to create calendar table

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

After my tests, blank values will not affect the result. You could check if your data used text type.

And you could add filter to ignore blank values.

calender =
CALENDAR (
    MIN ( project[contract start date] ),
    CALCULATE (
        MAX ( project[contractenddate] ),
        FILTER ( project, project[contractenddate] <> BLANK () )
    )
)

[littlemojopuppy]

You could create it with CALENDARAUTO.  It'll look at all the date fields and create a continuous list from the first date found to the last one

[az38]

hi @Anonymous 

blank values shouldn't be an issue.

please, provide a data example to help you