Sum Rows By Month Withour Group

[Anonymous]

Hey,

I Work with different langaue so I put a text box with english translation.

I Want to create with M langaue, a calculated column that will calculate the total LOG column by month, but the Group column will stay (without group again).

Which function can I use? I want to create this column for calculating the percentage of each group by each month from the total hours of the month.

Thanks!

**At the picture I meant to "Monthly Houres Per Month"

[AlB · Accepted solution]

@Anonymous 

Place the following M code in a blank query to see the steps.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCk4tKEnNTUotUtJRcgRiCyMLc6VYHVQJJyA2NzUyA0v4J5fkI9SbW1oYogmDVRsZWIKF/fLLkI23NDQyRhcHqbc0MTQBi7ukJqOoNzHBEAepNzW3sFCKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Month = _t, Group = _t, #"LOG Hours" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Month", type text}, {"Group", type text}, {"LOG Hours", Int64.Type}}),

    #"Grouped Rows" = Table.Group(#"Changed Type", {"Month"}, {{"Count", each _}, {"Sum", each List.Sum([LOG Hours]), type nullable number}}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"Group"}, {"Group"})
in
    #"Expanded Count"

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlB]

@Anonymous 

Either. If you're going for the excel file, you have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

http://s000.tinyupload.com/?file_id=23417201716332753014

Thanks!

[AlB]

Hi @Anonymous 

You can do this with Group By

Can you share the contents of the table in text format, so that it can be copied and we can provide an exact solution

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

Hey,

In Excel file? or just write it here?