Search found 26 matches

by luca
Wed Jul 10, 2019 2:23 am
Forum: Power Query
Topic: Trasform grouped header in a proper table [Solved]
Replies: 2
Views: 1032

Re: Trasform grouped header in a proper table [Solved]

Hi, How about this: trasform in a table.xlsx M-Code let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], #"Transposed Table" = Table.Transpose(Source), #"Filled Down" = Table.FillDown(#"Transposed Table",{"Column1"}), #"Promoted Head...
by luca
Fri Jun 28, 2019 1:04 am
Forum: Power Query
Topic: Trasform grouped header in a proper table [Solved]
Replies: 2
Views: 1032

Trasform grouped header in a proper table [Solved]

Hi all,

i would like to trasform the following table using power query.
the excel grouped header has to be the header of the new table while the year has to become a column
can anyone help me with this transformation.
Thanks
bye
Luca
by luca
Fri May 17, 2019 5:57 pm
Forum: Power Query
Topic: Sum of a column
Replies: 8
Views: 1420

Re: Sum of a column

You can create a new column based on the Total created by the Total Step. eg: = Table.AddColumn(#"Create Calc", "Total Value", each Total) Thanks Rudi. The second question was about creating a "total with a filter" (so the same formula you suggested for the total but i...
by luca
Thu May 16, 2019 1:15 am
Forum: Power Query
Topic: Sum of a column
Replies: 8
Views: 1420

Re: Sum of a column

How about this: (See comments in the M code.) let //Connect to 2 column table source representing values you posted. //Column 1 titled: "Data 1"; Column 2 titled: Data 2 Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], //Sum up [Data 2] and store value in Step: Total ...
by luca
Thu May 16, 2019 1:05 am
Forum: Power Query
Topic: Sum of a column
Replies: 8
Views: 1420

Re: Sum of a column

How about this: (See comments in the M code.) let //Connect to 2 column table source representing values you posted. //Column 1 titled: "Data 1"; Column 2 titled: Data 2 Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], //Sum up [Data 2] and store value in Step: Total ...
by luca
Wed May 15, 2019 8:21 am
Forum: Power Query
Topic: Sum of a column
Replies: 8
Views: 1420

Sum of a column

Hi guys, is possible to add a custom column with a formula which include a line reference to another column divided by the total value of a third column. So for example A B Calculated column 1 2 1/10 (sum of B column) 2 5 2/10 4 3 4/10 thanks Luca
by luca
Thu May 09, 2019 6:36 am
Forum: Power Query
Topic: Unpivot Columns
Replies: 3
Views: 948

Re: Unpivot Columns

Try this: 1 - MERGE Rev1 and Prepayment fields (Rev1 first), pick a unique delimeter (ie | ) 2. - UNPIVOT as required 3. SPLIT Value column - by delimeter 4. The first column is the Rev, the Second column will be Prepayments. Rename and reorder as required. See attached for steps. Desired result no...
by luca
Mon May 06, 2019 10:45 pm
Forum: Power Query
Topic: M Language Syntax problem from Excel 2013 to 2016
Replies: 2
Views: 722

Re: M Language Syntax problem from Excel 2013 to 2016

Just thinking out loud, as have no definite idea on what could be wrong. Did you just open the file in the new version, or copy things across? Am wondering if the "" are an issue after a copy paste? Have you retried typing the line out, in case that removes any characters affecting things...
by luca
Fri May 03, 2019 2:26 am
Forum: Power Query
Topic: M Language Syntax problem from Excel 2013 to 2016
Replies: 2
Views: 722

M Language Syntax problem from Excel 2013 to 2016

Hi All, i cant figure out why i am getting this problem after passing from excel 2013 to 2016. The syntax seems correct and also PQ editor says that it is fine but then the step is considered wrong. =Text.Select(Text.Start([IdRisorsa],2),{"A".."Z"}) The formula worked perfectly i...
by luca
Thu Apr 18, 2019 7:21 pm
Forum: Power Query
Topic: Unpivot Columns
Replies: 3
Views: 948

Unpivot Columns

Hi Guys,
can you help me with the following problem. Attached the result desired. In short i have to unpivot "Rev." values and expand list of dates but i have to do that without impacting on prepayments column
Any suggestion?
Thanks
Luca

Go to advanced search

cron