Recent content by GPnew

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...

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...

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

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

Yes Thanks That is how it looks

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...

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...

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"...

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...

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...

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...

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...

Thanks works great

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...