Search results

Suggest you load some sample data worksheets. In this manner, we can examine what you have and have completed.

A sample workbook with 10-15 rows of data would certainly help. Then show us what you would like those 10-15 rows to look like in a PT. Can't help what we cannot see.

Problem opening file

Save as a PDF and forward as such

An alternative that does not require you do any coding

It would be helpful seeing the data. That being said, I think the problem may be that PQ cannot sort a null value. Maybe change the null to something else, ie. 3 in your if statement.

A power query solution let T1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], T2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], MQ = Table.NestedJoin(T1, {"HHS"}, T2, {"Column1"}, "T3", JoinKind.RightOuter), #"Expanded T3" = Table.ExpandTableColumn(MQ, "T3"...

Read my signature. Its there.

Used Power Query. Here is the Mcode that is in the workbook let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Transposed Table" = Table.Transpose(Source), #"Changed Type" = Table.TransformColumnTypes(#"Transposed Table",{{"Column1", type date}}), #"Transposed...

crossposted: https://www.myonlinetraininghub.com/excel-forum/excel/how-to-combine-rows-in-power-query#p31192 which has a solution.

Look at the attached and see if you can go forward from there. Not sure what exactly your results should look like as your input and output fields do not match up and my crystal ball is out for repairs.

I cannot manipulate your data. All the cells are text and will not convert to numerical data. In order to do averages, these "numbers" need to be real numbers and not text data that look like numbers.

It would be helpful if you took your data in the above post and uploaded it as a file. Currently, when I try to manipulate that data it is all text and I cannot convert it to numbers without re-typing. I do have a solution for you but I need your sample data in a file.

If I am understanding correctly, Filter on 37 and then join the two tables. I have built a parameter table where you can enter the appropriate AccountBK and then refresh the query.

When I join the two tables on the common field, I get no matches for the Account BK Here is my Mcode to join the two tables let T1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], T2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], MQ = Table.NestedJoin(T1...

Is the common field Jouranl Entry BK. Is that what we should be joining on.

It would be very helpful if you provided some sample data of 10 to 15 records for each so that we can visualize and manipulate. With the sample data, mock up what you want the solution to look like so we can replicate. Do not load pictures as we cannot manipulate data in a picture. Upload...

Show us the code with the refresh directions so that it can be analyzed.

I do not see a PBNO field and definitely no sheet called VD-Sales. So what data do you wish to extract and what do you want the result to look like. Take a few rows of your data and show us a mocked up solution. My crystal ball is out for repairs, so I have no idea what you are trying to do...

Your customer Numbers do not match up. But a simple unpivot should work. You will have an extra column when you unpivot but you can remove it before close and load.

First Part let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Name", "Region", "Department"}, "Attribute", "Value"), #"Added Custom" = Table.AddColumn(#"Unpivoted Other Columns", "Custom", each if [Value]...

Show us a mocked up solution based upon the sample provided. BTW, pictures are of little value as the data cannot be manipulated. Attaching a sample file is the preferred method so that we don't have to re type your data.

if you wish to change the source and use a file path, then create a parameter query. https://exceloffthegrid.com/power-query-using-parameters/

crossposted: https://www.mrexcel.com/board/threads/what-is-a-good-tutorial-to-start-with-learning-power-bi.1252706/

If your users are not going to be modifying the workbook, you could hide the columns and then protect the workbook. But, keep in mind, excel is not as secure as you might think. A sharp user could unprotect the workbook and then unhide the columns if they could determine your password and are...