Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Rolling 12 months

Hi All,    i need to calculate rolling 12 months from received date and make it a calculated column. Reason is because i need to create groupings based on the cost range these values fall under.  ...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Download the revised PBI file from here.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Ashish_Mathur , 

Should be from July going back 12 months for each FY, summarised by vendor. And if it spills over, it goes into an 'Exceeded' bucket. 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Is this the result you are expecting?  You may download my PBI file from here.

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Ashish!

     

    Appreciate your help. Unfortunately the requirement is to be able to use the Levels measure as a slicer value which is where i'm struggling. That was why i was trying to calculate rolling 12m in a calculated column so that i could assign levels via  a column and then use taht as a slicer. 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      Download the revised PBI file from here.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Saved my day! Thank you so much this is exactly how i needed it to work! Appreciate it very much