Search found 26 matches

by h_gp9
Fri Apr 27, 2018 3:52 am
Forum: Power Query
Topic: Data Normalization
Replies: 3
Views: 1990

Re: Data Normalization

Hi Matt: After Normalization, how to carry "reference" to another excel workbook in order to combine with more database. thanks in advanced. ⋅ connect to the source data ⋅ set this query so it doesn't load. In PBI, right click and turn off "enable load". In Ex...
by h_gp9
Wed Nov 22, 2017 4:58 am
Forum: Power Query
Topic: Treat one power query table with 2 million rows as source for another
Replies: 1
Views: 1155

Treat one power query table with 2 million rows as source for another

I have a Power Query Table named as Final Table - this table has been loaded to the Data Model. I would like to use this Table (Final Table) as a source for creating another Power Query Table but has 2 million rows. How to call this Final table if I Can't display it in a single table but Connection ...
by h_gp9
Wed Nov 22, 2017 4:57 am
Forum: Power Query
Topic: Treat one power query table with 2 million rows as source for another
Replies: 1
Views: 1416

Treat one power query table with 2 million rows as source for another

I have a Power Query Table named as Final Table - this table has been loaded to the Data Model. I would like to use this Table (Final Table) as a source for creating another Power Query Table but has 2 million rows. How to call this Final table if I Can't display it in a single table but Connection ...
by h_gp9
Tue Sep 19, 2017 3:03 am
Forum: Power Query
Topic: Input data in a table and then refresh in another
Replies: 6
Views: 2989

Re: Input data in a table and then refresh in another

I've done with successful the query that I wanted.
Still I have doubt if is possible make this without add columns. but your suggestions for now are working.

Thank you for your suggestions
by h_gp9
Thu Sep 14, 2017 9:40 am
Forum: Power Query
Topic: Input data in a table and then refresh in another
Replies: 6
Views: 2989

Re: Input data in a table and then refresh in another

Dear Matt: I'll try with your method and I'll let you know. We take in account that only we are refresh one column [PO Price] , how about if we need refresh 10 or more colums? There is no a formula such as "RecordFromTable" or something like that in order to avoid add columns and then dele...
by h_gp9
Thu Sep 14, 2017 1:02 am
Forum: Power Query
Topic: Input data in a table and then refresh in another
Replies: 6
Views: 2989

Re: Input data in a table and then refresh in another

Your appreciation is useful. The key for update will be [Material Number], mainly. I need if there is a [Material Number] in both tables then one refresh to another one (New to Current) 1.- How do I refresh "CurrentPrice" based only in effective rows from "NewPrice" including dat...
by h_gp9
Wed Sep 13, 2017 4:17 am
Forum: Power Query
Topic: Input data in a table and then refresh in another
Replies: 6
Views: 2989

Input data in a table and then refresh in another

I need to refresh "PreviousPrice" table with "NewPrice" table only with data appears in "New Price" without alter another lines. Fields to update: [PO Price] , [Freight] After that I Need to recalculate other columns such: [Unit Act] Will be equals to = [PO Price] + [Fr...
by h_gp9
Thu Sep 07, 2017 12:52 am
Forum: Power Query
Topic: Update values from another table
Replies: 2
Views: 1844

Re: Update values from another table

Very sorry I don't understand your suggest.
Could you kindly send me a real code that include numbers?

Thanks
by h_gp9
Tue Sep 05, 2017 10:10 am
Forum: Power Query
Topic: Update values from another table
Replies: 2
Views: 1844

Update values from another table

Good day to all dear member: I have two sheet in the same worbook: "New Price" & "Previous Price" I need to replace new price instead previous price according with column headers common between both (Material Number, PO Price, etc) After this update, I need to recalculate col...
by h_gp9
Sat Jun 17, 2017 12:53 am
Forum: Power Query
Topic: Identify New Rows, Common Rows and Original Rows
Replies: 6
Views: 3576

Re: Identify New Rows, Common Rows and Original Rows

Hi Mitchandsuky:

When I try to run power pivot I get errors that I send to you in as attachment.
Could you help me please? thanks in advanced.

Go to advanced search