I have a data in below format and i want to take Life to date data in next to Sales column. Example 2017 row should reflect 100+200+300= 600. Can someone help me on this.
just create a simple measure like below:
Measure = CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'[Year]),'Table'[Year]<=MAX('Table'[Year])))
by the way, for this problem, you could have a look these blog:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.