Last seen: Jun 15, 2025
Suggest you attach a file that shows sample data that is representative of your actual file. Then mock up your expected results so that we understand...
The print in your picture is too small to read. You would be better served attaching your workbook for analysis.
This worked for me. let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Replaced Value" = Table.ReplaceValue(Source,"Notebook 5"...
Nothing attached. Please try again.
One approach I took was to create a pivot table in Power Pivot. Create a measure to group the unit codes and unit names.
crossposted: Suggest you read:
Cannot manipulate data in a picture. Please reattach a sample file with mocked up expectations.
Sample data would be very helpful to providing you with a solution. Updates some sample data and a mocked up solution so that we know exactly what yo...
Format Column C as a number. In your file it is general.
crossposted at:
Look at this link for a tutorial on PQ and Future Value Calculation.
Not from a picture. Load a sample file and explain what your expected results should be versus what you are getting.
nothing attached. Suggest a file instead of a picture.