Standard Financial report

Hi, paolomint 

Based on your description, I add new data in the table.

Table:

Test:

Year(a calculated table):

Year = DISTINCT('Table'[Year])

Here are the measures.

CurrentYear = 
var _info = SELECTEDVALUE(Test[Info])
var _year = SELECTEDVALUE('Year'[Year])
var _revenues = 
CALCULATE(
        SUM('Table'[Revenues]),
        FILTER(
            ALLSELECTED('Table'),
            'Table'[Year] = _year
        )
)
var _directcost = 
CALCULATE(
        SUM('Table'[Direct cost]),
        FILTER(
            ALLSELECTED('Table'),
            'Table'[Year] = _year
        )
)
var _indirectcost = 
CALCULATE(
        SUM('Table'[Indirect cost]),
        FILTER(
            ALLSELECTED('Table'),
            'Table'[Year] = _year
        )
)
var _capex = 
CALCULATE(
    SUM('Table'[Capex]),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Year] = _year
    )
)
return
SWITCH(
    TRUE(),
    _info = "Revenues",
    _revenues,
    _info = "Direct cost",
    _directcost,
    _info = "Indirect cost",
    _indirectcost,
    _info = "Ebitda",
    _revenues-_directcost-_indirectcost,
    _info = "Capex",
    _capex,
    _info = "Ebit",
    _revenues-_directcost-_indirectcost-_capex,
    BLANK()
)

LastYear = 
var _info = SELECTEDVALUE(Test[Info])
var _year = SELECTEDVALUE('Year'[Year])-1
var _revenues = 
CALCULATE(
        SUM('Table'[Revenues]),
        FILTER(
            ALLSELECTED('Table'),
            'Table'[Year] = _year
        )
)
var _directcost = 
CALCULATE(
        SUM('Table'[Direct cost]),
        FILTER(
            ALLSELECTED('Table'),
            'Table'[Year] = _year
        )
)
var _indirectcost = 
CALCULATE(
        SUM('Table'[Indirect cost]),
        FILTER(
            ALLSELECTED('Table'),
            'Table'[Year] = _year
        )
)
var _capex = 
CALCULATE(
    SUM('Table'[Capex]),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Year] = _year
    )
)
return
SWITCH(
    TRUE(),
    _info = "Revenues",
    _revenues,
    _info = "Direct cost",
    _directcost,
    _info = "Indirect cost",
    _indirectcost,
    _info = "Ebitda",
    _revenues-_directcost-_indirectcost,
    _info = "Capex",
    _capex,
    _info = "Ebit",
    _revenues-_directcost-_indirectcost-_capex,
    BLANK()
)

Diff = [CurrentYear]-[LastYear]

Result rate = 
DIVIDE(
    [CurrentYear]-[LastYear],
    [LastYear]
)

You may use a matrix visual to display the result.

Best Regards

Allan

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