Forum Discussion

inigo-montoya's avatar
inigo-montoya
Copper Contributor
Apr 21, 2022
Solved

Power Query from dynamic URL

Hey Guys,   so I am not too sure about my skillset but I would say im advanced ( I have played around a fair bit with power querys but mostly simple stuff as reformatting data, I havent had anythin...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 21, 2022

    inigo-montoya 

    That could be like

    let
    thisDate = Date.From(DateTime.LocalNow()),
    day = Date.Day(thisDate),
    adjustedDate =
        if day > 21
        then Date.AddDays( thisDate, 15)
        else thisDate,
    year = Text.From( Date.Year(adjustedDate) ),
    month = Number.ToText( Date.Month(adjustedDate), "00"),
    URL = "https://www.google.com/sites/default/files/documents/" & 
           year & month & "%WEIRDTEXTHERE"
in
    URL
inigo-montoya's avatar
inigo-montoya
Copper Contributor
Apr 23, 2022
thank you very much. While I understand the code and its function, where would I put this for the query?
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 23, 2022

inigo-montoya 

In Power Query editor that's Home->Advanced Editor and correct your code manually in it.

  • inigo-montoya's avatar
    inigo-montoya
    Copper Contributor
    Apr 25, 2022

    SergeiBaklan thank you so much for the help works exactly as I wanted! 

     

     

      • inigo-montoya's avatar
        inigo-montoya
        Copper Contributor
        May 23, 2022

        This would be a follow up so I guess its better than opening up a new Thread:
        Do you think it would be (somewhat easily) possible to create a Graph of the last months/years?
        basically like a Graph which shows the Development of the last 6 Months (im looking for a easier solution besides simply creating 6 Queries)

         

         
         

         

         

Resources