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!

 

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

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

    You are welcome.