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)
Greg_Deckler
Community Champion
Community Championvika160 - I created Net Work Days for this. https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362#M109
I would avoid DATESBETWEEN - https://community.powerbi.com/t5/Quick-Measures-Gallery/To-bleep-With-DATESBETWEEN/m-p/1252805#M581