Forum Discussion

ringovski's avatar
ringovski
Helper II
4 years ago
Solved

Calendar include blanks

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 a...
DAX Commands and Tips
Need Assistance
Need Help DAX
  • amitchandak's avatar
    amitchandak
    4 years ago

    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())

amitchandak's avatar
amitchandak
Super User
4 years ago

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())

ringovski's avatar
ringovski
Helper II
4 years ago

Thanks for reply should have thought that myself.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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

     

    Appreciate your help