Forum

Hi Allison, I've not come across that problem before and I couldn't reproduce it. You can't change the default settings on inserting of the chart, ...

Hi Laura, In order to use the RELATED function you need the tables to actually be related, which as you're aware, they aren't and it doesn't appear...

Hi John, You can use Fill Down to copy the data down as required. See file attached. Mynda

Hi Nawaf, First, I'm not sure why you would re-save each workbook as a .xlsm file when Power Query can get the data from the original CSV files IT ...

Ah, yes, that's a JavaScript table. If you have a Microsoft 365 version of Excel you can use the new STOCKHISTORY function to get that data. Myn...

Hi Punith, I can't read that image, but I think it's given me just enough to follow what you're trying to do. In the attached file I've taken one o...

Hi Bruno, You can keep your layout for data entry and then use Power Query to create the unpivoted layout of the data containing your calculations....

Hi Rebekka, Thanks for sharing your file. You need to unpivot your data and put it into a proper tabular format. Then you can use Tables or PivotTa...

Hi Punith, Welcome to our forum! I'm a bit confused because you say that the data format you're getting from Power Query is as shown in your fir...

Hi Bruno, Your data in the main tab isn't in a Tabular format. You need to unpivot columns D:F, then you can merge the tables to bring in the price...

Not really. Table.FromRecords creates a table from lists. You've got tables that you want to extract columns from to make a new table.

Hi Robb, Thanks for the file. Click on the last step in the query editor > go to the formula bar and remove the double quotes around the #time(....

Hi Craig, I think I must have had your original workbook open and not noticed that the revised workbook had 'a' appended to the end of the workbook...

Hi Leanne, Change MIN to MIN(IF...: =SEQUENCE(1,26,MIN(IF((Table14[Status]="Accepted")+(Table14[Status]="In Progress"),B5:B7))+'Data Entry = Pro...

Hi Scotty, If you want to retain the original columns after merging, go to the Add Column tab and Merge from there. Mynda