Forum Discussion
yugofukuda
5 years agoHelper IV
Accumulated Sum using no date
Hi, I would like to create a formula which accumulates measure using no date (Age). Could you please teach me how to do that??
- 5 years ago
Hi yugofukuda ,
Create a measure as below:
Measure = SUMX(FILTER(ALLSELECTED('sample'[Age]),'sample'[Age]<=MAX('sample'[Age])),[DIf])And you will see:
For the related .pbix file,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
yugofukuda
5 years agoHelper IV
Hi, does somebody help me out...??
v-kelly-msft
5 years agoCommunity Support
Hi yugofukuda ,
Create a measure as below:
Measure = SUMX(FILTER(ALLSELECTED('sample'[Age]),'sample'[Age]<=MAX('sample'[Age])),[DIf])
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!
- yugofukuda5 years agoHelper IV