Why my calendar function is not working ? Please help

[sandip]

Hi,

I am using the below DAX code:

Date Table =

var TBL_Date =

SELECTCOLUMNS(

FILTER(

ADDCOLUMNS(

'Parent Task SLA',

"Start Time", 'Parent Task SLA'[start_time],

"End Time", 'Parent Task SLA'[end_time]

),

[End Time] <> BLANK()

),

"Start Time",[Start Time],

"End Time", [End Time]

)

var TBL_Calendar = CALENDAR(TBL_Date[Start Time],TBL_Date[End Time])

return TBL_Calendar

but below error message is showing:

Cannot find table 'TBL_Date' or cannot find column Start Time

Please help me?

[v-xuding-msft]

Hi @sandip ,

The range of dates is from the specified start date to the specified end date, inclusive of those two dates. You write two columns in the calendar function rather than two dates.

CALENDAR 

The formulas that @amitchandak suggests should work perfectly. Or you could just write like this:

TBL_Calendar =
CALENDAR ( MIN ( TBL_Date[Start Time] ), MAX ( TBL_Date[End Time] ) )

 Creating Calendar Table in Power BI using DAX Functions 

[amitchandak · Accepted solution]

@sandip , try like

CALENDAR(minx(TBL_Date,TBL_Date[Start Time]),maxx(TBL_Date,TBL_Date[End Time]))

or

CALENDAR(minx(TBL_Date,[Start Time]),maxx(TBL_Date,[End Time]))

[sandip]

Hi,

Actually your second expression works well for me like below:

Date Table =

var TBL_Date =

SELECTCOLUMNS(

FILTER(

ADDCOLUMNS(

'Task SLA',

"Start Time", 'Task SLA'[start_time],

"End Time", 'Task SLA'[end_time]

),

[End Time] <> BLANK()

),

"Start Time",[Start Time],

"End Time", [End Time]

)

var TBL_Calendar = CALENDAR(minx(TBL_Date,[Start Time]),maxx(TBL_Date,[End Time]))

return

TBL_Calendar