Forum Discussion

kar2022's avatar
kar2022
Frequent Visitor
3 years ago
Solved

Adding calculated Rows using Power Query

Hi, I am struggling to add rows in the same table using Power Query.  Basically, I want to used the row data (by date) and create additional rows (Cal1 and Cal2) for the same dates and calculating a...
Need Help
  • kar2022's avatar
    kar2022
    3 years ago

    Hi Greg,

     

    Thank you very much.  It works fine.  However, when I make changed in my file it does not works.  I "Appended" a new data file with "Date", "Player", "Score" for a new player.

     

    Where would I add it?.  Not very good with "M".  Thanks for the helpl

     

        Custom = Table.Combine(#"Added Custom"[Custom],{"Player”,"Date", "Score","PrevScore"}),

        #"Added Custom1" = Table.AddColumn(Custom, "Player", each ([Score]-[PrevScore])/[PrevScore]),

        #"Removed Columns" = Table.RemoveColumns(#"Added Custom1",{"Score", "PrevScore"}),

        #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Date", Player", "Score"}),

        #"Appended Query" = Table.Combine({#"Reordered Columns", Captain})

    in

        #"Appended Query"

kar2022's avatar
kar2022
Frequent Visitor
3 years ago

If I add prior to the Append Query, what sytex should I use?

kar2022's avatar
kar2022
Frequent Visitor
3 years ago

Hi Greg,

I was to reference my file (prior to Append) and manage to do it.  Is this a good practice?.  Also, how do I add another custom formula?

(#"Added Custom1"),  In our example, I want to add a new "Cal3" (like we have Cal1 and Cal2).