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
that's not a good way to display data. you can create measure if you only want to see it once.
Hi ryan_mayu thank you very much, will check to change it to measure