Show past year sales on current year line

[evgeniystuchalk]

Hello!

I have app with caledar with fact data on several years.

I want to build table mith measure Past Year Sales, that will be shown in one line with current year. It's critically important, to see past year sales in line of current year.

My current psta year sales formula is.

Sum({$<[Тип даты]={'Закрытие сделки'}, [Win]=-{0},[YEAR]={$(=max(YEAR)-1)}>}[Бюджет])