Forum

Hi Jim, You need to add a helper column to the source data that classifies the kids into 1 or 2 kid families. See attached. Mynda

Hi William, Welcome to our forum! Unpivot the values columns. Then split the column containing the label; Total Sales History, Processed sales h...

Hi Martina, Welcome to our forum! Remove the fields from the Rows area that you don't want. You didn't include the field list in your screenshot...

I gave you a solution above. Did you try it?

Hi Alina, The forum is for specific Excel questions you're having difficulty with. I can't build your whole report, sorry. It sounds like you need...

Hi Alina, You'd need two Slicers, one for one set of charts and one for the other set. That said, if I were you I'd just apply the filters to the v...

Hi Sanju, It's a bit tricky to follow your explanation because there are no #N/A errors in cells A14 or A15 in the file linked to so I'm not clear ...

Hi Jim, You can do this easily with a PivotTable. Put the 'Kids' field in both the Rows and Values area of the PivotTable. Set the field in the Val...

1. This is done by Power Query automatically when you get files from a folder. 2. The first query under the 'Other Queries' folder is created autom...

Thanks for providing the sample files. You'll see in the attached I used Get Files from Folder and that you need to duplicate the final query two more...

Ah, not all of the information was provided with your first question. I suspect there is more you haven't explained, like; 1. will each file in the...

Hi Jacek, You can append the tables. See file attached. Mynda

Hi Aye, You can use a Power Query merge to compare two lists. See attached. Mynda

Hi Christoph, You can't add rows to a Power Query table in an Excel worksheet and then refresh the query which adds new rows and expect those rows ...

Hi Alina, Thanks for clarifying. Please see pbix file attached. You'll see it returns the same chart as you gave in your Excel file originally. ...