Forum Discussion

coco6l's avatar
coco6l
Frequent Visitor
2 years ago

Cumulative sum

I have two curves representing the hours planned and completed for each month. I'd like to sum up the hours planned for each year, then calculate this sum and subtract the hours actually worke...
Interesting Links
Need Help
Tutorial Requests
mh2587's avatar
mh2587
Super User
2 years ago
//Try this
Difference (Planned - Actual) = 
VAR SumPlannedHours = SUM('Heures prévues'[Heures Prévues])
VAR SumCompletedHours = SUM('Heures réalisées'[Heures Réalisées])
VAR PlannedHoursPerYear = CALCULATE(SumPlannedHours, ALLEXCEPT('Date Table', 'Date Table'[Year]))
VAR CompletedHoursPerYear = CALCULATE(SumCompletedHours, ALLEXCEPT('Date Table', 'Date Table'[Year]))

RETURN
PlannedHoursPerYear - CompletedHoursPerYear
  • coco6l's avatar
    coco6l
    Frequent Visitor
    2 years ago


    Hello mh2587,
    Thank you very much for the reply. I wanted to do sth like this exactly, I still have the problem that "heures prévues" is measure style and so I can't sum? 
    If ever here is my structure and my measure "heures prévues".

     

    Heures prévues = 
VAR YearOfDate = YEAR(MAX('Heures réalisées'[Date])) // ou MIN, selon la granularité de vos données
RETURN
DIVIDE(
    SWITCH(
        YearOfDate,
        2023, SUM('Heures prévues'[Nbre Heures initial 2023]),
        2024, SUM('Heures prévues'[Nbre Heures initial 2024]),
        BLANK()
    ),
    12
)

     


    Thanks