Forum Discussion
Sumx with Dynamic Year
Hello, I got a question. I want to make the following formula with a new column: % = Umsatz[Umsatz]/SUMX(FILTER(Umsatz;Umsatz[Bereich]="Ums"&&Umsatz[Jahr]=2017);Umsatz[Wert]) But instead of 201...
do you have a date in that row???
If yes use YEAR(Table[date]).
Hopefully this is what you are looking for!