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 create calendar table
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 () )
    )
)

     

3 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    hi Anonymous 

    blank values shouldn't be an issue.

    please, provide a data example to help you

  • 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

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    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 () )
    )
)