Filtered Value

[Hnowotny17]

Hello,

I would like to ask you for a help.

I have folowing columns. Turnover, Date, Year, Month.

I am trying to create pivot table, where will be Turnover 2021 (First column), Turnover 2022 (Second column) and Evolution % (Third column), but at the moment I am blind.

First, I wanted to create measures Turnover 2021, Turnover 2022 by filtering column Turnover by Date, but my formula wasn´t successful. 

Can anyone try to help me?

Many thanks!

Jan N 

[Mark_Little]

HI @Hnowotny17 

Might be worth sharing what you have tried, as it would appear you would want sopmething like

SUM(<{Year={2021}}>[Turrnover EUR])