Forum Discussion

CoreyLearnsBI's avatar
CoreyLearnsBI
Frequent Visitor
3 years ago

Adding More Than One Custom Column

How do I get my query to show all 4 custom columns I've created? It's only showing 1 of the 4 custom columns, despite having 4 separate steps to add 4 custom columns.   Here is an example of 1 of t...
Need Help
Chewdata's avatar
Chewdata
Icon for Responsive Resident rankResponsive Resident
2 years ago

Can you post the entire M-code for the query?

Go to advanced editor and copy.

Chewdata's avatar
Chewdata
Icon for Responsive Resident rankResponsive Resident
2 years ago

Like Anonymous says, you should reference the previous step in your code. The code should look something like this:

let
    Source = YOURSOURCE,
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Input", Int64.Type}}),
    add_Custom1 = Table.AddColumn(#"Changed Type", "Custom1", each [Input] + 1),
    add_Custom2 = Table.AddColumn(add_Custom1, "Custom2", each [Input] + 2),
    add_Custom3 = Table.AddColumn(add_Custom2, "Custom3", each [Input] + 3),
    add_Custom4 = Table.AddColumn(add_Custom3, "Custom4", each [Input] + 4)
in
    add_Custom4

 all steps are referencing the previous step. Finaly the last step is referenced in the 'in' part of the code, so all steps are evaluated and loaded.