Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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"
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
Hi @Anonymous Thank You it worked!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.