How to create a Calculated Table for Future Values in from a Unique Name list

Hi aar0n

Try this Calculated Table

From the Modelling Tab>> New Table

New Table =
ADDCOLUMNS (
    GENERATE (
        TableName,
        GENERATESERIES ( TableName[Last date in dataset] + 1, DATE ( 2020, 1, 1 ) )
    ),
    "myvalue", TableName[Last Known Value ]
        * .77
        ^ ( 1 / 12 )
)

Hi aar0n

In that case, create a New Table which will give you Month Numbers

Table =
GENERATE (
    TableName,
    GENERATESERIES (
        1,
        DATEDIFF ( TableName[Last date in dataset], DATE ( 2020, 1, 1 ), MONTH )
    )
)

Then you can add a calculated column to get Month End Dates

Column =
EOMONTH ( 'Table'[Last date in dataset], 'Table'[Value] )