Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Daily Sum

Hi Good day, Can anyone help me on how can i achieved my desired output. I need the sum of Daily Plan regardless of location. The Total Plan/day is the sum of Plan Hrs per planDate.   DESIRE...
  • Khushidesai0109's avatar
    1 year ago

    Hii AllanBerces 
    if you need it your way this can be done

    Total Plan/day =
    VAR TotalPerDay =
    CALCULATE(
    SUM('YourTable'[Plan Hrs]),
    ALLEXCEPT('YourTable', 'YourTable'[PlanDate])
    )

    VAR FirstOccurrenceCheck =
    RANKX(
    FILTER('YourTable', 'YourTable'[PlanDate] = EARLIER('YourTable'[PlanDate])),
    'YourTable'[Plan Hrs],
    ,
    ASC,
    DENSE
    )

    RETURN
    IF(FirstOccurrenceCheck = 1, TotalPerDay, BLANK())



    But the main thing to do it to create measure as it is more appropriate 
    Total Plan/day =
    CALCULATE(
    SUM('YourTable'[Plan Hrs]),
    ALLEXCEPT('YourTable', 'YourTable'[PlanDate])
    )
    Did I answer your question? Mark my post as a solution!
    I'd appreciate the kuddos as well