Search Results - Excelguru.ca

My Power Query breaks when source files with new names are put into the source folder

Started by Soproni, 2020-03-16 09:17 PM

Replies: 2
Views: 1,483

Last Post By:: Last Post: 2020-03-17 04:30 PM; by Soproni

Forum:
Power Query (Get & Transform) & M code

Append Queries with different Colulmn Names

Started by asjones987, 2020-02-07 08:01 PM

Replies: 2
Views: 1,085

Last Post By:: Last Post: 2020-02-09 08:41 PM; by Ken Puls

Forum:
Power Query (Get & Transform) & M code

Create a PQ function to complement the missing interval with the specified interval

Started by Inetguru, 2019-11-07 08:03 PM

Replies: 1
Views: 691

Last Post By:: Last Post: 2019-12-14 10:23 PM; by Inetguru

Forum:
Power Query (Get & Transform) & M code

Calculating a % relative to a previous row / Referencing other rows in calculation

Started by SimonCJ, 2019-11-13 11:48 AM

calculatedcolumn, calculation, power query, row reference, variance

Replies: 6
Views: 984

Last Post By:: Last Post: 2019-12-02 08:53 PM; by Bob Phillips

Forum:
Power Query (Get & Transform) & M code

Nested BOM structures that exist in only 2 columns in the db

Started by jjsararas, 2019-10-06 12:54 AM

Replies: 9
Views: 2,249

Last Post By:: Last Post: 2019-11-16 01:07 AM; by jjsararas

Forum:
Power Query (Get & Transform) & M code

Power Query M: List of dates until day t is needed

Started by christiane.latte, 2019-11-12 04:31 PM

Replies: 2
Views: 892

Last Post By:: Last Post: 2019-11-13 08:49 AM; by christiane.latte

Forum:
Power Query (Get & Transform) & M code

30d Average - Power Query

Started by Julien, 2019-10-24 11:02 PM

averageifs, moving average, partition, power query

Replies: 2
Views: 782

Last Post By:: Last Post: 2019-10-30 11:41 PM; by Julien

Forum:
Power Query (Get & Transform) & M code

Power Query vs Authorization

Started by IADmitriy, 2019-09-14 02:39 PM

Replies: 0
Views: 539

Last Post By:: Last Post: 2019-09-14 02:39 PM; by IADmitriy

Forum:
Power Query (Get & Transform) & M code

ExternelData_1 Error?

Started by Charley, 2019-08-26 06:40 PM

Replies: 5
Views: 2,003

Last Post By:: Last Post: 2019-08-28 02:21 AM; by Ken Puls

Forum:
Power Query (Get & Transform) & M code

Missing Functionality from Power Query - any ideas?

Started by Hypnopoison, 2019-05-27 05:48 PM

2 Pages •: 1 2

Replies: 10
Views: 2,537

Last Post By:: Last Post: 2019-06-05 05:31 PM; by Ken Puls

Forum:
Power Query (Get & Transform) & M code

Hiccups in exporting data to Excel from Notepad

Started by chv288115, 2019-05-17 04:41 PM

excel, power query, power query on excel dump

Replies: 3
Views: 2,311

Last Post By:: Last Post: 2019-06-05 04:23 PM; by p45cal

Forum:
Other General Questions

Lookup value from different row in same output column - circular reference error

Started by Costin, 2019-05-23 08:15 AM

circular reference, dax, lookup, power bi, power query

Replies: 2
Views: 1,335

Last Post By:: Last Post: 2019-05-24 11:28 AM; by BernardBrussels

Forum:
Power Query (Get & Transform) & M code

Track Power Queries and post to a dashboard

Started by bstirling, 2019-05-16 11:14 PM

Replies: 0
Views: 510

Last Post By:: Last Post: 2019-05-16 11:14 PM; by bstirling

Forum:
VBA Programming

Merge Two columns based on date

Started by mmoore5553, 2019-03-08 04:05 AM

3 Pages •: 1 2 3

Replies: 24
Views: 5,518

Last Post By:: Last Post: 2019-04-02 02:27 PM; by mmoore5553

Forum:
Power Query (Get & Transform) & M code

What's the best calendar strategy?

Started by Charley, 2019-02-20 10:35 PM

calendar, data model, dax, power pivot, power query

Replies: 4
Views: 1,979

Last Post By:: Last Post: 2019-03-25 10:05 PM; by Charley

Forum:
Power Pivot & DAX

Need a Unique Location Number

Started by ronblaisdell, 2019-03-12 07:20 PM

excel, m language, power query, unique id

Replies: 3
Views: 946

Last Post By:: Last Post: 2019-03-13 02:47 PM; by ronblaisdell

Forum:
Power Query (Get & Transform) & M code

Filter based on groups of rows with zero value

Started by GreenBoy, 2019-02-08 11:54 AM

Replies: 3
Views: 742

Last Post By:: Last Post: 2019-02-18 01:53 PM; by GreenBoy

Forum:
Power Query (Get & Transform) & M code

Run Power Query Routines in Sequence

Started by dburke, 2016-11-15 08:03 PM

Replies: 5
Views: 5,464

Last Post By:: Last Post: 2019-02-12 01:59 PM; by Vishal.Jagani

Forum:
Power Query (Get & Transform) & M code

Modifying the MCode for first sheet instead of named sheet

Started by rocaleon, 2019-02-08 07:20 PM

Replies: 3
Views: 988

Last Post By:: Last Post: 2019-02-08 08:53 PM; by horseyride

Forum:
Power Query (Get & Transform) & M code

Why is PowerBI called PowerBI?

Started by mail@peterspen.nl, 2019-01-26 10:41 AM

power, power bi desktop, power pivot, power query

Replies: 4
Views: 2,004

Last Post By:: Last Post: 2019-02-07 12:32 PM; by JoePublic

Forum:
PowerBI Desktop

how to debug "download did not complete" message in Power Query

Started by karimm, 2018-02-11 10:52 PM

Replies: 6
Views: 6,854

Last Post By:: Last Post: 2019-01-30 05:11 PM; by jdorbish

Forum:
Power Query (Get & Transform) & M code

Get and combine excel files from Sharepoint

Started by Martinl, 2019-01-08 01:34 PM

Replies: 2
Views: 874

Last Post By:: Last Post: 2019-01-15 11:34 AM; by Martinl

Forum:
Power Query (Get & Transform) & M code

Excel Powerquery: values not loading in excel, but visible in powerquery editor

Started by Koen92, 2019-01-08 01:51 PM

Replies: 1
Views: 716

Last Post By:: Last Post: 2019-01-09 11:12 AM; by Koen92

Forum:
Power Query (Get & Transform) & M code

Refreshing Queries using VBA - Message Alert for Queries that Failed to Refresh

Started by jdorbish, 2019-01-08 05:20 PM

Replies: 0
Views: 827

Last Post By:: Last Post: 2019-01-08 05:20 PM; by jdorbish

Forum:
Power Pivot & DAX

Moving a specific column to the begining with a dyanamic table

Started by gjohal, 2018-12-27 10:05 PM

Replies: 2
Views: 727

Last Post By:: Last Post: 2018-12-28 07:37 PM; by gjohal

Forum:
Power Query (Get & Transform) & M code

Search:

Search: Search took 0.01 seconds.

My Power Query breaks when source files with new names are put into the source folder

Append Queries with different Colulmn Names

Create a PQ function to complement the missing interval with the specified interval

Calculating a % relative to a previous row / Referencing other rows in calculation

Nested BOM structures that exist in only 2 columns in the db

Power Query M: List of dates until day t is needed

30d Average - Power Query

Power Query vs Authorization

ExternelData_1 Error?

Missing Functionality from Power Query - any ideas?

Hiccups in exporting data to Excel from Notepad

Lookup value from different row in same output column - circular reference error

Track Power Queries and post to a dashboard

Merge Two columns based on date

What's the best calendar strategy?

Need a Unique Location Number

Filter based on groups of rows with zero value

Run Power Query Routines in Sequence

Modifying the MCode for first sheet instead of named sheet

Why is PowerBI called PowerBI?

how to debug "download did not complete" message in Power Query

Get and combine excel files from Sharepoint

Excel Powerquery: values not loading in excel, but visible in powerquery editor

Refreshing Queries using VBA - Message Alert for Queries that Failed to Refresh

Moving a specific column to the begining with a dyanamic table