Forum Discussion

nbitabc's avatar
nbitabc
Helper I
5 years ago
Solved

Dynamic Opening balance measure

Hello all,   We have a monthly aggregated snapshot table as data source, and I am trying to come up with a dynamic begining balance measure.  This is the structure of our data with entry for each ...
  • deodatto's avatar
    5 years ago

    hi friend,

    you try use a isonvalue or isinscope? you have two modes to calculate, month and year, use a isinscope in you meansure. anda create a meansure to calculate separate values to last month, and sum of values to use more effective.
    best regards