Forum Discussion

munna825's avatar
munna825
New Member
6 years ago
Solved

Creating Trailing Twelve Month Sum with a measure - Turnover Rate

I am struggling to create a TTM chart that displays the sum of the last 12 months turnover rate. Calculating the turnover rate in itself was confusing. Now that I have the turnover rate I would like ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi munna825 ,

     

    You could check the measure below.

    Measure 2 = SUMX(FILTER(ALL('Table'),'Table'[Year-Month]<=SELECTEDVALUE('Table'[Year-Month])&&'Table'[Year-Month]>EDATE(SELECTEDVALUE('Table'[Year-Month]),-12)),[Measure])

    And the result in table visual will be shown as below.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi munna825 ,

 

You could check the measure below.

Measure 2 = SUMX(FILTER(ALL('Table'),'Table'[Year-Month]<=SELECTEDVALUE('Table'[Year-Month])&&'Table'[Year-Month]>EDATE(SELECTEDVALUE('Table'[Year-Month]),-12)),[Measure])

And the result in table visual will be shown as below.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.