Search found 19 matches

by mitchandsuzy
Tue Nov 07, 2017 12:03 pm
Forum: Power Query
Topic: Using Parameters to select a column
Replies: 1
Views: 118

Using Parameters to select a column

Okay, I thought this would be so simple, but no at least not for me! What I am trying to do is create a function that removes all the data (or Filters actually) based on what the current month is. If this is November the I do not want any results from November showing because it is only a partial fi...
by mitchandsuzy
Thu Mar 30, 2017 10:51 pm
Forum: Power Query
Topic: Identify New Rows, Common Rows and Original Rows
Replies: 6
Views: 1168

Re: Identify New Rows, Common Rows and Original Rows

Hi H,

Please find attached file. Just put the two files in the same directory as the excel file and go into power pivot and you will see what I think you wanted.

Suzy
by mitchandsuzy
Tue Mar 28, 2017 10:37 am
Forum: Power Query
Topic: Identify New Rows, Common Rows and Original Rows
Replies: 6
Views: 1168

Re: Identify New Rows, Common Rows and Original Rows

Hi H,

I would take me ages to sanitize my data to send to you.

However if you would like to send me a sample of your files I will add the code into file for you and you can step through the code yourself to see how it works.

Suzy
by mitchandsuzy
Sun Mar 26, 2017 6:04 pm
Forum: Power BI Desktop/Service
Topic: Slow running Queries Power BI and Power Query
Replies: 2
Views: 811

Re: Slow running Queries Power BI and Power Query

Hi Matt, Thanks for taking the time to understand my question. I have just gone through and sanitized my data so I could send it through to you. I hope this helps explain this issue. I need to do this because when I report I can never be sure that data I am using is the correct version, as we have m...
by mitchandsuzy
Thu Mar 23, 2017 12:05 pm
Forum: Power Query
Topic: Identify New Rows, Common Rows and Original Rows
Replies: 6
Views: 1168

Re: Identify New Rows, Common Rows and Original Rows

Hi H, Matt showed us a way to do this at one of our User Group meetings. let SolutionPath = fnGetParameter("File Path"), <---- this just gets the current directory Source = Folder.Files(SolutionPath), #"Lowercased Text" = Table.TransformColumns(Source,{{"Name", Text.Low...
by mitchandsuzy
Thu Mar 09, 2017 9:03 am
Forum: Power BI Desktop/Service
Topic: Slow running Queries Power BI and Power Query
Replies: 2
Views: 811

Slow running Queries Power BI and Power Query

Hi everyone, This issue has perplexed me and despite making changes I still have a very slow refreshing table in Power Query & Power BI. I have data extracted from SAP. I have no idea whether everyone using SAP has the same arrangement for data but I will explain what we have just in case. We ha...
by mitchandsuzy
Mon Dec 19, 2016 10:14 am
Forum: Power Query
Topic: Combining multiple records and fields into a single record
Replies: 2
Views: 546

Re: Combining multiple records and fields into a single record

Thank you Matt, Unfortunately not all information is being recorded on each "level" so in order to get all the information for the record I need to combine all the data from the 2 (sometimes 3) data records for that single project. Eg Project Category is recorded on the "dash1" b...
by mitchandsuzy
Fri Dec 16, 2016 2:29 pm
Forum: Power Query
Topic: Combining multiple records and fields into a single record
Replies: 2
Views: 546

Combining multiple records and fields into a single record

Merry Christmas Everyone! Thank you for taking the time to read my question. I have a problem with an exceedingly long running PQ. I have a project that has several sub levels which with monotonous regularity have data included on one or the other level sometimes on both and sometimes different on ...
by mitchandsuzy
Thu Nov 03, 2016 11:58 am
Forum: Power Query
Topic: Finding the name of a column in a Power Query
Replies: 9
Views: 1801

Finding the name of a column in a Power Query

Thanks so much Maxim!!!! :D I was trying to use Table.ColumnNames but could not figure out how to do it properly, I wish I had kept what I was doing so I could see what I did wrong - it just kept telling me I needed a list or something similar... I give you the "Hero of the Day Award" you ...
by mitchandsuzy
Mon Oct 31, 2016 12:17 pm
Forum: Power Query
Topic: Finding the name of a column in a Power Query
Replies: 9
Views: 1801

Re: Finding the name of a column in a Power Query

Thanks Matt,

I hadn't thought of that! I get so involved with finding a solution sometimes.

I would prefer to have dynamic column names so if you come across a method of finding a column name that would be great.

If I trip over it I will let you know as well.

Suzy

Go to advanced search