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?
