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...

NetWorkDays.pbix80 KB

Other

Time Intelligence

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!
- 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!