Calculate Monthly based on Cumulative Total

ISGirl Are the amounts in your table already cumulative amounts (i.e. there is no column that specifies the amount that each month had against it)?  If you have a monthly amount, you should be able to just drag the Amount field into a visual with the Period field without any measure.

I may be misunderstanding what you are after? Apologies on my end.

 I am so sorry for the misunderstanding! That is my bad.  This should help  

Monthly Amount = TOTALMTD ( SUM ( 'Table'[Amount] ) , 'Table'[Posted Date] ) - CALCULATE ( SUM ( 'Table'[Amount] ) , DATEADD ( 'Table'[Posted Date] , -1 , MONTH ) , ALL ( 'Table' ) )

 

The above can be broken down using variables as follows:

Monthly Amount = 

VAR _TotalMth = TOTALMTD ( SUM ( 'Table'[Amount] ) , 'Table'[Posted Date] )
VAR _TotalLstMth = CALCULATE( [Sum Amount] , DATEADD ( 'Table'[Posted Date] , -1 , MONTH ) , ALL ( 'Table' ) )

RETURN 

_TotalMth - _TotalLstMth

Hope this helps and apologies again!

Theo 🙂

ISGirl -

You might need some more tweaking if you have additional data but the example could serve as a template

Distributed Amount = 
DIVIDE(
    CALCULATE(
        MAX(TableName[Amount]),
        FILTER(
            ALL(TableName),
            TableName[FiscalYear]
        )
    ),
    CALCULATE(
        COUNTROWS(TableName),
        FILTER(
            ALL(TableName),
            TableName[FiscalYear]
        )
    )
)