Forum Discussion
Getting all dates between 2 dates excluding weekends
When you say you want to get all the dates between two dates, you mean you want the sum of those days?
for that there is a function in dax networkingDays q returns the number of working days (you must indicate the holidays of your country ..)
NETWORKDAYS(
https://learn.microsoft.com/en-us/dax/networkdays-dax
Now if what you want is dates like dateTime. I recommend you create another CALENDAR TABLE. Only with the working days. and when you do the beetwen of the two dates you use this table as a reference therefore the DateTime that is there are working days between those two dates ...
I hope I have helped you in something...
- Anonymous3 years agoNot applicable
Hello,
thank you, well so far I am using PowerApps to calculate Working days between these two dates (From / To) its working, but I need also sequence of days per day.
The reason : I am doing a lot of calculation and the idea is to view these calculations based on month and quarters and I cant think of any other solution how to incorporate it. So far its displaying my calculation only based on name, country etc...