Search found 23 matches

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

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

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

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

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

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

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

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

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

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

I followed those steps: To change the external data source used by a current connection 1.In the PowerPivot window, click the Home tab, and in the Connections group, click Existing Connections. 2.Select the current database connection and click Edit. For this example, the Table Import Wizard opens t...

Go to advanced search