Measure showing deviation (%) (timestamps in datainput are within one field)

[rainerpowerbi]

Hi,

I have datainput in a special structure and I want to keep this structure

The timestamp per period in datainput is within one field.

Is there a possibilty to create a measure to display the deviation (%) between timestamp 2020 to 2021

for example within a powerbi-matrix ?

Kind regards and thanks

Rainer

[themistoklis · Accepted solution]

@rainerpowerbi 

I would go for table instead of matrxi in case more years will be added to input data.

For the table you can create the following 3 measures:

2020 = CALCULATE(SUM('DataInput'[Sales]), FILTER('DataInput', 'DataInput'[time-stamp]=2020))

2021 = CALCULATE(SUM('DataInput'[Sales]), FILTER('DataInput', 'DataInput'[time-stamp]=2021))

Deviation = ([2021] - [2020]) / [2020]

[rainerpowerbi]

Thanks !