Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Hello, can you help? Power BI looping

Hello,  We are wondering how to we can change the parameters within a URL to different days, months, and years.  For example, analyzing the history of the Top 40 Charts:  http://top40-charts.com/c...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    This might work. It will create a URL for each date in for a set period of time. 

     

    1. Create a new table 
      Date = 
    ADDCOLUMNS(
        CALENDAR("1/1/1980", TODAY()),
             "Formatted", FORMAT([Date], "YYYY-MM-DD")
            )
    2. Create a column concating your URL and the formatted date 
      Column 2 = CONCATENATE("http//Top40-chart.com/chart.php?cid=27&date=", 'Date'[Formatted])
    3.  Format the data category to a URL
Anonymous's avatar
Anonymous
Not applicable
7 years ago

This might work. It will create a URL for each date in for a set period of time. 

 

  1. Create a new table 
    Date = 
    ADDCOLUMNS(
        CALENDAR("1/1/1980", TODAY()),
             "Formatted", FORMAT([Date], "YYYY-MM-DD")
            )
  2. Create a column concating your URL and the formatted date 
    Column 2 = CONCATENATE("http//Top40-chart.com/chart.php?cid=27&date=", 'Date'[Formatted])
  3.  Format the data category to a URL