split value monthly between two dates

Hi mauroanelli

You can try using this calculated Table in DAX

From the Modelling Tab >>>NEW TABLE

Table =
VAR temp =
    ADDCOLUMNS (
        GENERATE (
            Table1,
            GENERATESERIES ( MONTH ( Table1[date start] ), MONTH ( Table1[date end] ) )
        ),
        "No_of_Months", DATEDIFF ( Table1[date start], Table1[date end], MONTH ) + 1
    )
RETURN
    SELECTCOLUMNS (
        temp,
        "Project", [project],
        "Month", EOMONTH ( [date start], [Value] - 2 )
            + 1,
        "MonthlyValue", [total value] / [No_of_Months]
    )

HI mauroanelli

See the attached file here

(With your sample data)