Forum Discussion

cassidy's avatar
cassidy
Icon for Power Participant rankPower Participant
6 years ago
Solved

Extract Dates from Date Range & Unpivot

I couldn't find this exactly example, sorry if it's repeat.   I want to allow users to type in 4 columns....Product, Promotion, Start Date, & End Date.  This happens in an Excel file on OneDrive. ...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi cassidy 

     

    look at this.

     

    List.Dates([Start Date], Duration.Days([End Date] - [Start Date]), #duration(1, 0, 0, 0))

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi cassidy 

 

look at this.

 

List.Dates([Start Date], Duration.Days([End Date] - [Start Date]), #duration(1, 0, 0, 0))

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

  • cassidy's avatar
    cassidy
    Icon for Power Participant rankPower Participant
    6 years ago

    That's it! Thank you