Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

Calculation annual change (values in columns)

Hello! I am stuck in my dashboard where I need to make a simple subtraction of some values (Difference in € compared to the previous year), but since I have the layout of the table in columns, I have...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Syndicate_Admin ,

     

    Because this formula is conformed in my scenario, your PBIX doesn't have this table name, you need to replace the name of each table in the formula with the name of the table in your own PBIX

    For example, in your picture: table name: 2022-1

    Measure =
var _today=TODAY()
var _2022=
SUMX(
    FILTER(ALLSELECTED('2022-1'),
    '2022-1'[flujo]=MAX('2022-1'[flujo])&&'2022-1'[cod_taric]=MAX('2022-1'[cod_taric])&&
    '2022-1'[ano]=YEAR(_today)-1),[euros])
var _2023=
SUMX(
    FILTER(ALLSELECTED('2022-1'),
    '2022-1'[flujo]=MAX('2022-1'[flujo])&&'2022-1'[cod_taric]=MAX('2022-1'[cod_taric])&&
    '2022-1'[ano]=YEAR(_today)),[euros])    
return
_2023 - _2022

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Syndicate_Admin ,

 

You can try the following dax:

Measure =
var _today=TODAY()
var _2022=
SUMX(
    FILTER(ALLSELECTED('Table'),
    'Table'[flujo]=MAX('Table'[flujo])&&'Table'[cod_taric]=MAX('Table'[cod_taric])&&
    'Table'[ano]=YEAR(_today)-1),[euros])
var _2023=
SUMX(
    FILTER(ALLSELECTED('Table'),
    'Table'[flujo]=MAX('Table'[flujo])&&'Table'[cod_taric]=MAX('Table'[cod_taric])&&
    'Table'[ano]=YEAR(_today)),[euros])    
return
_2023 - _2022

 

 

Best Regards,

Liu Yang

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