Forum

Hi Michelle, What Purfleet said. In the meantime, have you tried putting in proper cell references instead of whole column references? If you want ...

Hi Rob, It's difficult to troubleshoot without the file. Have you tried just adding the formula rather than copying it from another cell? i.e. type...

Hi Ken, Our formulas are not the same. Your formula is: =List.Min({[start]}) Mine is: =List.Min(#"Changed Type"[#"start"]) Replace your...

Hi Anne, I would get the data into a new file using this technique to get data from multiple files containing multiple sheets with Power Query, exc...

Hi Troy, You can use the SWITCH fucnction: =SWITCH(MONTH(dCalendar[Date]),9,1,10,1,11,1,12,2,1,2,2,2,3,3,4,3,5,3,6,4,7,4,8,4) Mynda

Hi Ken, Add a custom column that returns the 'List.Min' for the Stamp Date column. The formula looks like this: =List.Min(#"Changed Type with Lo...

Hi Sue, Thanks for sharing. It works well for data that's in your worksheet, but it won't load the data to the data model because it requires a ref...

If your # column had the same number for the buy and sell data then you could use that to group the rows in the PivotTable. See attached on the 'Ask' ...

Hi Sue, Excel doesn't have an option to refresh the query at a specific time, only time intervals. Nor can a file execute a refresh when it's close...

Hi Kanit, Welcome to our forum! When the file opens in the Power Query editor window, click on 'Table' in the 'LIST_G_C6' column. Then click on ...

Hi Maree, Pulling in a stored query simplifies the job of getting the data you need. Other than that it works in the same way. Mynda

Hi and welcome to our forum! The double click on a PivotTable cell will only display the items specific to that cell. You can't 'update' it as such...

Doesn't look good. I'm not aware of a fix other than to start from scratch 🙁

Hi Liz, It's as Brian predicted. Your months are not in a date format that Excel recognises as dates, therefore it treats the month names as any ot...

Hi Rosa, Please provide a sample Excel file so we can see what errors you're getting and the data structure you're working with. Mynda