Forum Discussion
Daily Sum
- 1 year ago
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
you can try this
Hi ryan_mayu MattiaFratello thank you very much for the reply, is it possible the sum will appeared only once in each date, the same as my example for the calculated column.
Than you
- AllanBerces1 year agoPost Prodigy
- ryan_mayu1 year agoSuper User
that's not a good way to display data. you can create measure if you only want to see it once.
- AllanBerces1 year agoPost Prodigy
Hi ryan_mayu thank you very much, will check to change it to measure