Forum Discussion
Sum Rows By Month Withour Group
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 th...
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
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