New column that subtract two rows of a table

[Anonymous]

Hello people,

I am new to Power BI. I need a new column that subtracts two rows of a table.

I have this table, and I need show the anual growth of each database, so I want to generate a column that subtracts the USED_GB of the current year less those of the previous year of each database.

The idea is to generate this new column in DAX. How can I do that?

Thanks.

[Anonymous]

Hi Ajendra, 

This is the desire output, but I would like not view the rows with PREVIOUS_YEAR with empty values:

Thanks. 

[FreemanZ]

hi @Anonymous 

try to add a calculated column like:

column = 
VAR _pre =
    MAXX(
        FILTER(
            data,
            data[DATABASE]=EARLIER(data[DATABASE])
                &&YEAR(data[DATE])=YEAR(EARLIER(data[DATE]))-1
        ),
        data[USED_GB]
    )
RETURN
    [USED_GB] - _pre

it worked like:

[Anonymous]

Hi FreemanZ, thanks for your help. 

I tried this, but my PowerBi showed this error (My table name is

'Consulta_Tamaño_Historico'), it seems to be related with EARLIER function. 

Regards. 

[Ajendra]

Hello,

Please provide some dummy data alongwith the desire output. Thanks!!

Ajendra!