Forum Discussion
formula placement
Hi, trying to figure out how to best model this formula. I have a simple sales table (however my actual data is very large, but for this example i'm using simple columns). Order Number S...
Thanks guys but I found this link was helpful for what i was trying to do. So far i think it works
https://www.sqlbi.com/articles/counting-working-days-in-dax/
Seems right.
Workdays = ([promise date] - [Ship date]) * 1.
Workdays = ([promise date] - [Ship date]) * 1.
Thank you Greg_Deckler , another question, how would i apply the calc to only show the difference for working days (excluding weekends?)