Forum Discussion
Helper IIICalculation days between dates excluding weekends and holidays
- Ok, this is most likely because the 'tblDate'[DateKey] is not in the same format as the V_PBI_APPLICATION_STATUS[App End Date]
They either both need to be DateKey (such as 20200714) or Date (such as July 14, 2020)
Community ChampionDo you want inclusive or exclusive of the open and end dates? Just add or remove the equal sign as needed in the inequalities below (as a new column in the V_PBI_APPLICATION_STATUS table):
COLUMN =
VAR _maxDate = IF (
NOT(ISBLANK(V_PBI_APPLICATION_STATUS[App End Date])),
V_PBI_APPLICATION_STATUS[App End Date],
TODAY ()
)
RETURN
COUNTROWS (FILTER( ALL('tblDate'),
'tblDate'[DateKey]>= V_PBI_APPLICATION_STATUS[Open Date]
&& 'tblDate'[DateKey]<=_maxDate
&& 'tblDate'[IsWorkingDayCode] = TRUE
)) -1
Helper IIIit returns -1 for all rows.
- AllisonKennedyOk, this is most likely because the 'tblDate'[DateKey] is not in the same format as the V_PBI_APPLICATION_STATUS[App End Date]
They either both need to be DateKey (such as 20200714) or Date (such as July 14, 2020)- vika160
HI Allison,
I thought about it.
I have another column in Date table that is the same format as End and Start date. I relinked these fields and tried.
I got the same error.
I can easily do this n sql but it is very frustrating I cannot figure this out in DAX. I am very new to DAX.
Thanks