topic Re: Calendar include blanks in DAX Commands and Tips

Calendar include blanks

ringovski — Mon, 14 Mar 2022 01:32:24 GMT

Hi,

I have a start & end date with some blanks in the rows which I would like included, I need to handle them differently in the visual layer. However the DAX calendar function says blanks are not allowed.

I tried adding a IF(ISBLANK()) but this returns a error saying end date must be larger than start date, so I'm out of ideas now.

Delivery Days = COUNTROWS ( FILTER ( ADDCOLUMNS ( CALENDAR ( 'Toll_Shipments'[Pick Up Date], Toll_Shipments[Actual Delivered Date] ), "Is Weekday",WEEKDAY([date],2)<6 ,"Is Holiday", CONTAINS('Holiday Dates','Holiday Dates'[Dates],[Date] ) ), [Is Holiday] = FALSE() && [Is Weekday] = TRUE() ) )

Thanks for any ideas or assistance.

Re: Calendar include blanks

amitchandak — Mon, 14 Mar 2022 02:33:59 GMT

ringovski , Try like

Work Day = if( not(isblank([Pick Up Date])) && not(isblank([Actual Delivered Date])) , COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Table[Pick Up Date],Table[Actual Delivered Date]),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1)), blank())

Re: Calendar include blanks

ringovski — Wed, 16 Mar 2022 03:44:02 GMT

Thanks for reply should have thought that myself.

Re: Calendar include blanks

Anonymous — Fri, 14 Oct 2022 03:03:23 GMT

Does the code fixed your problem? I come across to have error using the code above.

Appreciate your help