Search found 25 matches

by fb7894
Mon Jun 22, 2020 10:27 pm
Forum: Power Query
Topic: Excel cell causing error
Replies: 0
Views: 134

Excel cell causing error

Hello. I am reading in an Excel worksheet into PQ. One of my cells begins with an equal sign:
'=Hello World

This is causing an error with PQ. I cannot figure out how to fix this.
by fb7894
Wed May 13, 2020 5:16 am
Forum: Power Query
Topic: Pivot Columns
Replies: 0
Views: 312

Pivot Columns

How can I turn this table:

City...............State
Austin...........TX
Dallas...........TX
Los Angeles....CA
San Fransisco..CA
Houston........TX

Into this table

TX.........CA
Austin....Los Angeles
Dallas....San Fransisco
Houston
by fb7894
Wed May 13, 2020 5:11 am
Forum: PowerPivot/DAX
Topic: Calculated Column syntax
Replies: 2
Views: 205

Re: Calculated Column syntax

thanks!
by fb7894
Mon May 11, 2020 9:05 am
Forum: PowerPivot/DAX
Topic: Calculated Column syntax
Replies: 2
Views: 205

Calculated Column syntax

I need to create a calculated column with the following business rule: If any line item within a deal has a region <> "North America" then Global, else Regional Sample data Deal Line Item Region 1 100 Asia 1 101 North America 2 200 Asia 2 201 Europe 3 300 Asia 3 301 North America 4 400 Nor...
by fb7894
Fri Apr 10, 2020 12:04 am
Forum: Power Query
Topic: Auto populate credentials
Replies: 3
Views: 668

Re: Auto populate credentials

Thank you Matt. This is using Excel. The only way i know how to enter credentials is to manually go to Data > Get Data > Data Source settings > etc..... Most of my users are not that sophisticated in Excel. So sending them instructions is tough. Is there a way (using a VBA form maybe?)that they coul...
by fb7894
Fri Apr 03, 2020 3:57 am
Forum: Power Query
Topic: Auto populate credentials
Replies: 3
Views: 668

Auto populate credentials

I have a query/macro that several users will ultimately use. The PQ reads workbooks on an O365 Sharepoint site. Is there any way to auto populate the sharepoint credentials so that users don't need to put in credentials? If not, is there a glamour way to do this other than running the query, having ...
by fb7894
Wed Oct 02, 2019 12:51 am
Forum: Power Query
Topic: dealing with Excel #N/A
Replies: 1
Views: 367

dealing with Excel #N/A

I'm having problems where the Excel source I bring into PQ has #N/A results. Removing Errors in PQ does not seem to recognize these as errors.

How do you all deal with these #N/A cells?

Thanks!
by fb7894
Fri Jul 26, 2019 10:57 pm
Forum: Power Query
Topic: Dynamic reference to query [Solved]
Replies: 2
Views: 950

Re: Dynamic reference to query [Solved]

Thank you Phil. You're #1 !
by fb7894
Thu Jul 25, 2019 5:55 am
Forum: Power Query
Topic: Dynamic reference to query [Solved]
Replies: 2
Views: 950

Dynamic reference to query [Solved]

by fb7894
Wed Jul 10, 2019 3:53 am
Forum: Power Query
Topic: Standardize Date formats
Replies: 4
Views: 1135

Re: Standardize Date formats

Late addition.... what if I have a line of data like this....

This line is for June 4, 2019

Can I update the query to handle this format? The challenge is the spaces within the date.

Go to advanced search