Manipulating data form.

moussab_orabi

Following are the steps

Step#1 Create a New Table

Go to Modelling Tab >>>NEW TABLE

New_Table =
GENERATE (
    TableName,
    GENERATESERIES (
        YEAR ( TableName[Valid From] ),
        YEAR ( TableName[Valid To] ),
        1
    )
)

Step# 2 Change the Column Name from "Value" to YEAR

moussab_orabi

Step # 3 Add the YEAR PORTION column to this NEW TABLE

Year_Portion =
IF (
    YEAR ( 'New_Table'[Valid From] ) = 'New_Table'[YEAR],
    DIVIDE (
        DATEDIFF (
            'New_Table'[Valid From],
            MIN ( DATE ( YEAR ( 'New_Table'[Valid From] ), 12, 31 ), 'New_Table'[Valid To] ),
            DAY
        ),
        DATEDIFF ( 'New_Table'[Valid From], 'New_Table'[Valid To], DAY )
    ),
    IF (
        'New_Table'[YEAR] > YEAR ( 'New_Table'[Valid From] )
            && 'New_Table'[YEAR] < YEAR ( 'New_Table'[Valid To] ),
        365 / DATEDIFF ( 'New_Table'[Valid From], 'New_Table'[Valid To], DAY ),
        DIVIDE (
            DATEDIFF (
                DATE ( YEAR ( 'New_Table'[Valid to] ) - 1, 12, 31 ),
                'New_Table'[Valid To],
                DAY
            ),
            DATEDIFF ( 'New_Table'[Valid From], 'New_Table'[Valid To], DAY )
        )
    )
)
    * 'New_Table'[Quantity]