Forum Discussion
vika160
Helper III
Helper IIICalculation days between dates excluding weekends and holidays
I know there are tonns exaples here in a forum and on the web, but it seems that I find something for which I can not find a solution. I have a fact table with dates and a tbldates table with the Is...
- 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)
vika160Helper III
Helper IIIit returns -1 for all rows.
AllisonKennedy
Community Champion
Community ChampionOk, 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)
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