Rolling Year to Date Value for Each Operating Area

[patri0t82]

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'

[patri0t82 · Accepted 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])
)