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...
Need Help
  • Khushidesai0109's avatar
    Khushidesai0109
    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

Khushidesai0109's avatar
Khushidesai0109
Skilled Sharer
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

  • AllanBerces's avatar
    AllanBerces
    Post Prodigy
    1 year ago

    Hi Khushidesai0109 thank you very much for the reply, working good.