User Profile
Derek0834
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
DAX Measure for running total/cumulative across a date range.
Hi! I am looking for a dax measure to get a running total for the dataset below. I would like to be able to see this in a line chart format. So essentially it would give a value of 144 for the date 4/29/24 and 264 for 5/6/24. There are 3 key colums: Date Column that consists of a monday of each week. A value column that I would want to see the cumulative/running total A group column that would show me different groups information to be able to filter by or show different lines for. Start Of Week Value Group 4/22/2024 24 1 4/29/2024 120 1 5/6/2024 120 1 5/13/2024 120 1 5/20/2024 120 1 5/27/2024 120 1 6/3/2024 120 1 6/10/2024 120 1 6/17/2024 120 1 6/24/2024 120 1 7/1/2024 120 1 7/8/2024 120 1 7/15/2024 120 1 7/22/2024 120 1 7/29/2024 120 1 8/5/2024 120 1 8/12/2024 120 1 8/19/2024 120 1 8/26/2024 120 1 9/2/2024 120 1 9/9/2024 120 1 9/16/2024 120 1 9/23/2024 120 1 9/30/2024 120 1 10/7/2024 120 1 10/14/2024 120 1 10/21/2024 120 1 10/28/2024 120 1 11/4/2024 120 1 11/11/2024 120 1 11/18/2024 120 1 11/25/2024 120 1 12/2/2024 120 1 12/9/2024 120 1 12/16/2024 120 1 12/23/2024 120 1 12/30/2024 120 1 1/6/2025 120 1 1/13/2025 120 1 1/20/2025 120 1 1/27/2025 120 1 2/3/2025 120 1 2/10/2025 120 1 2/17/2025 120 1 2/24/2025 120 1 3/3/2025 120 1 3/10/2025 120 1 3/17/2025 120 1 3/24/2025 120 1 3/31/2025 120 1 4/7/2025 120 1 4/14/2025 120 1 4/21/2025 120 1 4/22/2024 24 2 4/29/2024 120 2 5/6/2024 120 2 5/13/2024 120 2 5/20/2024 120 2 5/27/2024 120 2 6/3/2024 120 2 6/10/2024 120 2 6/17/2024 120 2 6/24/2024 120 2 7/1/2024 120 2 7/8/2024 120 2 7/15/2024 120 2 7/22/2024 120 2 7/29/2024 120 2 8/5/2024 120 2 8/12/2024 120 2 8/19/2024 120 2 8/26/2024 120 2 9/2/2024 120 2 9/9/2024 120 2 9/16/2024 120 2 9/23/2024 120 2 9/30/2024 120 2 10/7/2024 120 2 10/14/2024 120 2 10/21/2024 120 2 10/28/2024 120 2 11/4/2024 120 2 11/11/2024 120 2 11/18/2024 120 2 11/25/2024 120 2 12/2/2024 120 2 12/9/2024 120 2 12/16/2024 120 2 12/23/2024 120 2 12/30/2024 120 2 1/6/2025 120 2 1/13/2025 120 2 1/20/2025 120 2 1/27/2025 120 2 2/3/2025 120 2 2/10/2025 120 2 2/17/2025 120 2 2/24/2025 120 2 3/3/2025 120 2 3/10/2025 120 2 3/17/2025 120 2 3/24/2025 120 2 3/31/2025 120 2 4/7/2025 120 2 4/14/2025 120 2 4/21/2025 120 2 4/22/2024 24 3 4/29/2024 120 3 5/6/2024 120 3 5/13/2024 120 3 5/20/2024 120 3 5/27/2024 120 3 6/3/2024 120 3 6/10/2024 120 3 6/17/2024 120 3 6/24/2024 120 3 7/1/2024 120 3 7/8/2024 120 3 7/15/2024 120 3 7/22/2024 120 3 7/29/2024 120 3 8/5/2024 120 3 8/12/2024 120 3 8/19/2024 120 3 8/26/2024 120 3 9/2/2024 120 3 9/9/2024 120 3 9/16/2024 120 3 9/23/2024 120 3 9/30/2024 120 3 10/7/2024 120 3 10/14/2024 120 3 10/21/2024 120 3 10/28/2024 120 3 11/4/2024 120 3 11/11/2024 120 3 11/18/2024 120 3 11/25/2024 120 3 12/2/2024 120 3 12/9/2024 120 3 12/16/2024 120 3 12/23/2024 120 3 12/30/2024 120 3 1/6/2025 120 3 1/13/2025 120 3 1/20/2025 120 3 1/27/2025 120 3 2/3/2025 120 3 2/10/2025 120 3 2/17/2025 120 3 2/24/2025 120 3 3/3/2025 120 3 3/10/2025 120 3 3/17/2025 120 3 3/24/2025 120 3 3/31/2025 120 3 4/7/2025 120 3 4/14/2025 120 3 4/21/2025 120 3 9/30/2024 120 4 10/7/2024 120 4 10/14/2024 120 4 10/21/2024 120 4 10/28/2024 120 4 11/4/2024 120 4 11/11/2024 120 4 11/18/2024 120 4 11/25/2024 120 4 12/2/2024 120 4 12/9/2024 120 4 12/16/2024 120 4 12/23/2024 120 4 12/30/2024 120 4 1/6/2025 120 4 1/13/2025 120 4 1/20/2025 120 4 1/27/2025 120 4 2/3/2025 120 4 2/10/2025 120 4 2/17/2025 120 4 2/24/2025 120 4 3/3/2025 120 4 3/10/2025 120 4 3/17/2025 120 4 3/24/2025 120 4 3/31/2025 120 4 4/7/2025 120 4 4/14/2025 120 4 4/21/2025 120 4 4/22/2024 24 5 4/29/2024 120 5 5/6/2024 120 5 5/13/2024 120 5 5/20/2024 120 5 5/27/2024 120 5 6/3/2024 120 5 6/10/2024 120 5 6/17/2024 120 5 6/24/2024 120 5 7/1/2024 120 5 7/8/2024 120 5 7/15/2024 120 5 7/22/2024 120 5 7/29/2024 120 5 8/5/2024 120 5 8/12/2024 120 5 8/19/2024 120 5 8/26/2024 120 5 9/2/2024 120 5 9/9/2024 120 5 9/16/2024 120 5 9/23/2024 120 5 9/30/2024 120 5 10/7/2024 120 5 10/14/2024 120 5 10/21/2024 120 5 10/28/2024 120 5 11/4/2024 120 5 11/11/2024 120 5 11/18/2024 120 5 11/25/2024 120 5 12/2/2024 120 5 12/9/2024 120 5 12/16/2024 120 5 12/23/2024 120 5 12/30/2024 120 5 1/6/2025 120 5 1/13/2025 120 5 1/20/2025 120 5 1/27/2025 120 5 2/3/2025 120 5 2/10/2025 120 5 2/17/2025 120 5 2/24/2025 120 5 3/3/2025 120 5 3/10/2025 120 5 3/17/2025 120 5 3/24/2025 120 5 3/31/2025 120 5 4/7/2025 120 5 4/14/2025 120 5 4/21/2025 120 5Custom Column Help
Can anyone help me to figure out how to create a new column in Power Query Editor that would take a Sum of Rated_Hours based on Request Week. For Example, 10/29/2023 would have a column next to it reading 37.6. I would then want to remove duplicates so I have 1 row that shows 10/29/23 and 37.6 total rated hours. Which in turn would allow me to create a one-many relationship with another table I already have established.
