Make a table using steps

[OscarSuarez10]

Hello How can I put this three steps In one table?

[v-juanli-msft]

Hi @OscarSuarez10 

Could you click on the icon to show me the detailed step?

Would you want to output the table with "year","cheme***" into another table as a single table?

If possible, could you show me the table before "Group Rows" step and final result after the following steps?

Best Regards
Maggie

[Syndicate_Admin]

@v-juanli-msft 

[OscarSuarez10]

@v-juanli-msft 

[OscarSuarez10]

Hello I Want to make a table like this:

Year	Ch Oil production	Ch Water Production	Ch Injected Production
2019	25280000	88880000	0
2020	363400000	150000000	0
2021	66050000	32210000	0

I used this steps:

#"Filtered Rows" = Table.SelectRows(#"Tipo cambiado3", each Text.Contains([Well], "CH")),
#"Grouped Rows" = Table.Group(#"Filtered Rows", {"Year"}, {{"Ch Oil Production", each List.Sum([WOPT]), type number}}),
#"Grouped Rows2" = Table.Group(#"Filtered Rows", {"Year"}, {{"Ch Water Production", each List.Sum([WWPT]), type number}}),
#"Grouped Rows3" = Table.Group(#"Filtered Rows", {"Year"}, {{"Ch Injectes Production", each List.Sum([WWIT]), type number}})
in
#"Grouped Rows3"

[Anonymous · Accepted solution]

Hi @OscarSuarez10 ,

    #"Filtered Rows" = Table.SelectRows(#"Tipo cambiado3", each Text.Contains([Well], "CH")),
    #"Grouped Rows" = Table.Group(#"Filtered Rows", {"Year"}, {{"Ch Oil Production", each List.Sum([WOPT]), type number}}),
    #"Grouped Rows2" = Table.Group(#"Filtered Rows", {"Year"}, {{"Ch Water Production", each List.Sum([WWPT]), type number}}),
    #"Grouped Rows3" = Table.Group(#"Filtered Rows", {"Year"}, {{"Ch Injectes Production", each List.Sum([WWIT]), type number}}),
    #"Join1" = Table.NestedJoin(#"Grouped Rows", {"Year"}, #"Grouped Rows2", {"Year"}, "Ch Water Production", JoinKind.LeftOuter),
    #"Expand1" = Table.ExpandTableColumn(#"Join1", "Ch Water Production", {"Ch Water Production"}, {"Ch Water Production"}),
    #"Join2" = Table.NestedJoin(#"Expand1", {"Year"}, #"Grouped Rows3", {"Year"}, "Ch Injectes Production", JoinKind.LeftOuter),
    #"Expand2" = Table.ExpandTableColumn(#"Join2", "Ch Injectes Production", {"Ch Injectes Production"}, {"Ch Injectes Production"})
in
    #"Expand2"

Could you try this ? 

I didn't try it on power bi but I hope I didn't make any mistakes.. If it does not works tell me i'll react as soon as possible 😉 

Regards, 

Etienne

[OscarSuarez10]

Hi @Anonymous  Thank You it worked!