Forum Discussion

sachintandon84's avatar
sachintandon84
Helper I
6 years ago
Solved

Power Query - list dates forward, but excluding weekends

How do I solve the attached problem.   I've been given the number of holidays requested by employees and their start request date, and would like to roll the dates forward by individual day, but ex...
Need Help
sachintandon84's avatar
sachintandon84
Helper I
6 years ago

Thanks Frank!

 

This is really, really helpful, though I am looking for a PQ solution, as I need to do this in Excel.

 

Any ideas on how I could do this with M-code?

 

Unless I use Power Pivot in some way?

 

Are you able to attach / provide a link to your DAX solution?  it might help me think of an M-Code solution for this problem

 

If you have the solution in Excel, that would also really help!

 

Sachin

  • sachintandon84's avatar
    sachintandon84
    Helper I
    6 years ago

    Thanks Mariusz, 

     

    This is a very clever solution, and will help me a lot!

     

    Thank you again!

     

    Kind regards, 

     

    Sachin

    • Mariusz's avatar
      Mariusz
      Community Champion
      6 years ago

      Hi sachintandon84 

      No problem, happy to help!


      Many Thanks

      Mariusz

  • CD_75's avatar
    CD_75
    Frequent Visitor
    2 years ago

    Thank you - this was exectly what I was looking for.