Forum Discussion
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...
Hii AllanBerces
if you need it your way this can be doneTotal 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
Hi AllanBerces, please use the following:
Total Plan Day =
CALCULATE(
SUM('Table (2)'[Plan Hrs]),
ALLEXCEPT('Table (2)', 'Table (2)'[PlanDate])
)