Forum

Hi Simeon, Please provide a sample file when you post a question so we don't have to recreate your data. You can do this with a combination of I...

Hi Adam If your Year is in A1 and the Day of Year in B1 you can use this =DATEVALUE(A1&"/1/1")+B1-1 Regards Phil

Hi Mattias, Please share your PBIX file so we don't have to recreate everything. Regards Phil

Hi Jose, Why are you using VBA for this? Just use a formula in Column J? If you are using Power Query to import the data every month, use that ...

Hi Scott, Please provide some sample data files and an example of how you want the results to look. Regards Phil

Hi, Please supply some sample data and an example of the result you want, otherwise anything we provide will need to be changed again to suit your ...

Hi Mike, Hasn't Mynda already answered you when you contacted her via Linked In and email? regards Phil

Hi Amir, You'll need to load it into Excel as a table, then save that file as a CSV - comma delimited - why use pipes as delimiters? Regards ...

Hi Amir, You might be able to do this with formulae, I hadn't thought about it as you asked for a solution with Power Query? Regards Phil

Hi Joe, You haven't included the URL of the web page you want to scrape. Can you explain clearly what it is you want to scrape. What is draught...

Hi Carolyn, Have you seen this article, it may help to work through it Get Data from OneDrive or Sharepoint with Power Query Regards Phil

Hi Lea, You can use Power Query to do this, see the attached file. These are the steps: 1. Create a table from your data (CTRL+T) 2. Set ...

Hi, Need a lot more info to help you. What error are you getting? Can you provide a screenshot? Why are you using Basic Auth? Does your int...

Hi, Please supply sample data in an Excel file. Hard to write any code without it. Regards Phil

Hi Amir, You haven't provided a sample of the data, or your query, so it's nearly impossible to tell you what is going wrong. If you look at the...