Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Net Work Days

Recreates the NETWORKDAYS function from Excel with some bonus measures and one that needs fixed or demonstrates a bug/documentation glitch.   NetWorkDays calculates the number of days between two...
Other
Time Intelligence
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Greg, i am using a direct query and it throws up an error saying countx is not allowed as part of calculated columns dax expressions on Direct Query Mode.. Please Help!!!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Greg,
    I am definatly using a measure!
    Below is the Error Message:
    MdxScript(Model) (189, 17) Calculation error in measure 'fact_CRM_Incident'[Business Days Active]: The start date in Calendar function can not be later than the end date.

    I would like to also reference my holiday flag column which is a Yes/No field in my dim_date table.

    On another note the Closed on date column contains blanks if a ticket is in an "active" or Open state in which case the business days calc should continue to count till current day until a closed date is added in the dataset.

     

    Appreciate the help mate.

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I am receiving the same error. Did you ever figure out the solution?

       

      Thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I infact did i used Greg's solution and created another measure to calculate weekends and holidays and subtracted from the above solution.  

        Anonymous wrote:

        I am receiving the same error. Did you ever figure out the solution?

         

        Thanks!