Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

How to Get Your Question Answered Quickly

Ever wonder why some questions get answered so quickly while others languish or are seemingly completely ignored? Fear not, this article will help guide you into getting your question answered quickl...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

I'm new to both Power BI and support forum. I have an issue for the data above. I'm trying to split this row into multiple rows but only want new lisat of rows to have work allocated only on workdays. I've managed to create a list column but it is creating a row including Saturday and Sunday. Any assistance is greatly appreaciated

 

Greg_Deckler 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    5 years ago

    @magshehab

    Try this as a new column in Power Query:

    List.Select(
  List.Transform(
    {Number.From([Start Date]).. Number.From([End Date])},
    each Date.From(_)
  ),
  each Date.DayOfWeek(_, 1) < 5
)

    Going forward, please create a new post with your questions rather than replying to another post. This will ensure that your question gets seen by more people and anwered much faster.

    Pete

    • mianai's avatar
      mianai
      Advocate I
      3 years ago

      Thanks for sharing such helpful information