Net Work Days | Microsoft Fabric Community

Greg_Deckler
Community Champion
7 years ago
Are you sure you are using the formula in a measure and not in a Column? According to this article, COUNTX should work in a measure:

https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016?view=sql-server-2017
- 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
    Not applicable
    7 years ago
    I am receiving the same error. Did you ever figure out the solution?
    
    Thanks!