Search found 25 matches

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: 65

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: 0
Views: 38

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: 441

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: 441

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: 441

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: 441

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: 340

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: 340

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: 1113

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.
by h_gp9
Wed Jun 14, 2017 7:29 am
Forum: PowerPivot/DAX
Topic: I edit connection but after: "We couldn't refresh the connection"
Replies: 15
Views: 1512

Re: I edit connection but after: "We couldn't refresh the connection"

Dear Matt:

I don't have relashionships is only a conexion from where take some columns and I need to refresh it with another file having the same estructure but I can't refresh it as you as seen it.

Go to advanced search