Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

calender table

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 crea...
Tips and Tricks
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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's avatar
littlemojopuppy
Community Champion
6 years ago

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