Forum

Hi, That's the way the PRODUCT function works and is the reason to use it in this case rather than just multiplying the three cells together, which...

Hi Julia, Check if the values in your [YTD Revenue USD] column are actually numbers. PQ is complaining that it's seeing text in that column. Re...

Hi Saliha, You can use an approximate match VLOOKUP for this - see attached file. regards Phil

Hi Matt, Yes a workbook with actual data is always better so that mistakes aren't made when recreating data from a written description of it. Al...

Hi Matt, If your data is in A1:A5 and you have the words to search for (e.g. big and house) in B1 and B2 then this works =COUNT(SEARCH(B1,$A$1:$...

🙂

Hi Jay, Without sample data it's pretty much impossible to help you - please provide a sample file with: 1. Enough data to properly represent yo...

Hi Rick, There isn't a specific section of the course dealing with JSON. I'm a little unclear as to what you are dealing with. You mention a JS...

Hi Laura, An alternative approach would be to create your query(ies) to the web source and load those results into a table(s) in Excel. Then the...

No worries

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 ...