Forum

Hi Paul, I don't see how you can choose a single site based on the group selected in the Group Report as groups have many sites. What is the logic ...

Hi Alexandra, Welcome to our forum! It looks like you're writing a measure, when comparing to your Excel forumula, what you actually want to wri...

You only needed to use the Local option for the date columns. The others could just have their data type set using 'detect data type' on the Transform...

Hi Jayanth, Please use 'Show Values As' for these calculations. I would provide you with a sample file but my beta version of Excel is crashing whe...

Hi Briana, To find cells that match a criteria you should use the FILTER function. To find a blank cell use "" as the criteria, as opposed to ze...

Hi Steve, When using the Excel.Workbook function the source file must be closed for Power Query to access it. Mynda

Hi Ulf, If you load the data into Power Pivot you can write a DAX measure to do this, see example attached. Mynda

Hi John, The problem is caused by the locale difference between your PC and the source data. Your date format is mm/dd/yyyy and the data is dd/mm/y...

Hi Nick, Thanks for sharing your file. You're absolutely right, the layout of your free throw data table is not suitable for analysing and PivotTab...

Hi Riste, I don't recommend using a formula for this task. In fact, I recommend you change the structure of the Plan sheet so that it's in the same...

Hi Mike, Welcome to our forum! The file isn't attached. I suspect you didn't clikc the 'Start Upload' button after selecting the file. Anyhow, I...

Hi and welcome to our forum! It's great to see you're practicing XLOOKUP. In this scenario you would only lookup Caps. There's no need to factor in...

Hi Alex, Since the page doesn't have any tables, you need to drill down on the Document tables until you find the information you want. In the atta...

Hi Saliha, In Excel 2016 you either have Power Pivot or you don't. You can't download an add-in for it. For more information on versions of Exc...

Hi Doug, Thanks for sharing your file. First, XLOOKUP; I don't see any issues with the XLOOKUP fomulas, so I'm not sure what your question is there...