March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello,
I'll explain my setup. My first column is called 'Month / Year' (a date column). My second column is called 'Operating Area' (a text column) and my third column is called 'Hours' (a number column).
I need to create a column that provides a rolling year-to-date sum of 'Hours' for each 'Operating Area'
Solved! Go to Solution.
I guess I found a solution using DAX outside of Power Query that works well. Thank you for your time.
Hours YTD =
TOTALYTD(
SUM('Hours Combined'[Hours]),
'Hours Combined'[Month / Year],
ALLEXCEPT('Hours Combined','Hours Combined'[Operating Area])
)
I guess I found a solution using DAX outside of Power Query that works well. Thank you for your time.
Hours YTD =
TOTALYTD(
SUM('Hours Combined'[Hours]),
'Hours Combined'[Month / Year],
ALLEXCEPT('Hours Combined','Hours Combined'[Operating Area])
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
20 | |
13 | |
10 | |
9 | |
7 |
User | Count |
---|---|
39 | |
27 | |
16 | |
15 | |
10 |