Forum Discussion

JustDavid's avatar
JustDavid
Helper IV
1 month ago
Solved

Repeat Rate by Period Range Text

Hello,   I'm trying to do a equivalent of "vlookup" that has the "closest match" in Power Query. But given the data that I had, am trying to know how I can create date from string range (i.e. Feb 2...
  • JustDavid's avatar
    1 month ago

    I was able to play and google around and was able to resolve it.

     

    What I did is create a 2 columns to get the 'start date' and 'end date' based on the text, and these 2 columns are date type.

    After which from (https://www.youtube.com/shorts/V6lEUNvbXug), I was able to create the list of dates from these 2 date columns