Log In
Register
Home
March 10, 2016
Offline
In the attachment I need cumulative hours of each week
Each week will give the cumulative FIX HOURS on Sundays through Thursdays inclusive
I need him to do the summary calculation for each week separately
How do you do that?
Thank you very much, Leah
See Answer
Trusted Members
October 18, 2018
Offline
Is this the result you would be looking for in the attached. If so, then this Power Query Mcode should be sufficient.
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"DATE", type date}}),
#"Inserted Week of Year" = Table.AddColumn(#"Changed Type", "Week of Year", each Date.WeekOfYear([DATE]), Int64.Type),
#"Removed Columns" = Table.RemoveColumns(#"Inserted Week of Year",{"Cumulative hours"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns",{{"SUM", Int64.Type}}),
#"Grouped Rows" = Table.Group(#"Changed Type1", {"Week of Year"}, {{"Total Hours Per Week", each List.Sum([SUM]), type any}})
in
#"Grouped Rows"
It would be very helpful, if you had supplied a mocked up solution so that we clearly understood your needs.
Answers Post
1 Guest(s)
