Forum Discussion
AllanBerces
2 years agoPost Prodigy
Sumx- Per Week
Hi good day, Pls need assistance on how can i get the sum per week base from Phase and Trade. Thank you
- 2 years ago
Hi Ashish_Mathur sivarajan21 mickey64 thank you to all your reply, i got the solution on my query.
Thank you
sivarajan21
2 years agoPost Prodigy
Hi AllanBerces ,
PFA measure to achieve your outcome
Sumxperweek =
CALCULATE(COUNTAX(Trade,Trade[Phase]),ALLEXCEPT(Trade,Trade[Phase],Trade[Week No.]))
The result is:
If you are satisfied with this, please accept it as a solution and give a kudos.
Thanks in advance!