Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GPnew
  • Order by date
  1. GPnew

    Power Pivot Filter out Rows where data is not in all columns

    Thanks Skip I am trying to make use of the power pivot /(datamodel) functionality and it allowed me to calculate the weighted average of sales price by part by year by using a measure , (and the other 2 measures as described) It means, each year going forward, I can just dump in the sales...
  2. GPnew

    Power Pivot Filter out Rows where data is not in all columns

  3. GPnew

    Power Pivot Filter out Rows where data is not in all columns

    Thanks Skip I don't think I have explained things very well. I am not sure how to easily create the table to apply the formulas to. I have actually got 3 tables in my power pivot data model 1. Label (Unique across 23 and 24 Years) FYI the "label" column is actually a column of part numbers...
  4. GPnew

    Power Pivot Filter out Rows where data is not in all columns

    Are you referring to a classic pivot table or a power pivot table ...which is where I have my problem?
  5. GPnew

    Power Pivot Filter out Rows where data is not in all columns

    Thanks for your comments What do you mean by "use PT global filter button to filter values"
  6. GPnew

    Power Pivot Filter out Rows where data is not in all columns

    Yes Thanks That is how it looks
  7. GPnew

    Power Pivot Filter out Rows where data is not in all columns

    I have created a power pivot table to show the % year on year (23 to 24) change, of the weighted average prices per part Not all parts had sales in both 23 and 24 = TRUE in the last column I would like to filter out the TRUE's or even create a slicer on that column When I dragged the column...
  8. GPnew

    Power Query

    Worked it out Apparently you cant save into a column/cell row type null. Therefore inserted a row to convert to unspecified.. RemoveNulls = Table.TransformColumns(#"Renamed Columns", {"Name", each if _ is null then "unspecified" else _}), TidyUpData = Table.ReplaceValue( RemoveNulls, each...
  9. GPnew

    Power Query

    Still no Joy ? Frustrating This is whst I have TidyUpData = Table.ReplaceValue( #"Renamed Columns", each [Name], each if Text.Contains([Employee_No], "TAL",Comparer.OrdinalIgnoreCase)=true then [Employee_No] else [Name], Replacer.ReplaceText, {"Name"}), FYI I tried adding a new column "Dept2"...
  10. GPnew

    Power Query

    Hi it is still not working. I tried this to test the else...ie to see if the "TAL" was recognised. It is TidyUpData = Table.ReplaceValue( #"Renamed Columns", each [Name], each if Text.Contains([Employee_No], "Tal")=true then [Employee_No] else "Bla", Replacer.ReplaceText, {"Name"}), and...
  11. GPnew

    Power Query

    I am newish to power query and have been struggling with the following when I think it should be quite simple I have loaded data from a pdf file. On one of the 30 or so lines of imported data that should be in the [Name} column , appears incorrectly in the [Employee_No] column. Therefore a...
  12. GPnew

    Give each line in group the same number on a report line

    Yep I couldn't work out what was happening. I couldn't run the process twice as the query kept on being blown away. I found the answer on Google ..there is a bit about the bug there ..appears to only happen when exporting to excel . It could related to poor code on my behalf ....but at least...
  13. GPnew

    Give each line in group the same number on a report line

    I ended up creating a table query , then making another table and some vba to tidy it up as I couldn't get the output in the right order on the output and the group numbering to work. One things I found out was that in creating the table the query was deleted ..so had to be re installed Ie...
  14. GPnew

    Power Query Extract from pdf

    Thanks works great
  15. GPnew

    Power Query Extract from pdf

    I am extracting data using power from a pdf file with headers and was wondering if there was an easy way to transform the data into a data cube in power query eg currently it imports like this Dept Sales Jo Bloggs 120 John Smith 100 Dept Sales Total 220 Dept Admin Ned...
  16. GPnew

    Access 2016 report export to excel column order changes

    Fair comment ..I have replied to my previous thread
  17. GPnew

    Give each line in group the same number on a report line

    Thanks it works a treat
  18. GPnew

    Access 2016 report export to excel column order changes

    Hi, I am exporting a report to excel but the order of the columns changes. I have checked the tab order and made sure they was correct. Also tried removing all the fields and adding them in order. This worked for most except on a calculated field that ended up in the last column Any Ideas
  19. GPnew

    Give each line in group the same number on a report line

    Sure The same number for each line in the subgroup. FYI the number is in the first column of the report Sub Groups (based on date) . FYI in my actual report there is no gap between groups 1 2/2/2022 100 subgroup 1 1 2/2/2022 200 subgroup 1...
  20. GPnew

    Give each line in group the same number on a report line

    Yes sorting and grouping used ....but I must have it set up wrong. Rather than adding the same number to each "detail" line in the subgroup , it adds an increasing number to each line... eg 1 to the first line on the subgroup ..then 2 to the next line in the subgroup.., The (increasing)...

Part and Inventory Search

Back
Top