Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the app we have data for funds balance from year 1997 to future months. But when I display in the chart I wanted to show I wanted to use display month year field instead of year month field.
Display Month year field is populated from Apr 2016 onward to future months ( 2018). But our final expression should take the previous months balance and then accumulate from there. Even though users filter the data on display fiscal year should always start the values from all previous months total and then accumulate.
Let me know if you have any other questions
May be this, assuming you have QV12
Aggr(RangeSum(Above(Sum({<DisplayMonthYear, DisplayYearMonth>}[Funds Balance final]), 0, RowNo())), (YearMonth, (NUMERIC)))
May be this, assuming you have QV12
Aggr(RangeSum(Above(Sum({<DisplayMonthYear, DisplayYearMonth>}[Funds Balance final]), 0, RowNo())), (YearMonth, (NUMERIC)))
thank you rey that is what i wanted.