Hi
I have table With multiple loans, and each of them has a value called [End Balance USD].
I am trying to put these data in a chart With a Dimension Drilldown that goes from Year-YearQuarter-YearMonth-YearWeek-Date.
I do not know how to Write the correct set analysis to get the correct loan Balance in these periods, I end up getting the sum of all periods if I Select any lower granularity than Date.
Anyone that know how to Write an Expression that will pick the value from either the first date or last date in period?
Br Espen