Forum Discussion
joshua1990
Post Prodigy
Post ProdigyAdd Working Days to Date with Weekends
Hi experts!
I have a column that contains the date. Then I have a second column with number of Days I would like to add to this column. These values represents just working days. But I would like to know the final date incl. weekends.
How would you do that in DAX and in Power Query?
2 Replies
johnt75Super User
SQLBI have a video on this, https://www.youtube.com/watch?v=2HkBbqxBzF0
joshua1990How would you do this in PQ based on ImkeF approach?
https://www.thebiccountant.com/2020/02/20/date-networkdays-function-for-power-query-and-power-bi/