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.

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

What table is the calculated column on?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi AlexisOlson ,

     

    It's calculated on my Data table (not my calendar table). i suspect that's causing an issue? Essentially i need to get rolling 12 months at each date point in my fact/data table but as a calculated column so that i can use that column to categorise my fields into dollar buckets.