Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Rollover Calcuation

Hello all,   I have a matrix with rows in it like this:   MONTHS    JAN  FEB  MAR  APR   MAY  EXPECTED     10     8        7       9        9 CAPACITY       8     8         8      8        8  ...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Anonymous ,

    I believe this is what you were looking for, yes? I had to add a couple of columns, one I called Excess, and one I called Real Date, as using the months did not work per se. As text the min is April and the max is May.

    Here is my PBIX Rollover
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi Anonymous ,

I believe this is what you were looking for, yes? I had to add a couple of columns, one I called Excess, and one I called Real Date, as using the months did not work per se. As text the min is April and the max is May.

Here is my PBIX Rollover
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes, this worked for me.  I just had to put it into a matrix and switch the rows and columns.  Thanks so much.