Search results for query: *

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

Fair comment ..I have replied to my previous thread

Thanks it works a treat

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

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

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