Compar of the current year with the previous year

[LeaRupnik]

i have a problem how to comer a previous year and current year. In current year (2020) a don't have all data. 

If I do this like manual selection in filter is ok. now I would like to do automatically with measure. 

if a do like this  a get just year 2019 and 2018.

sum pak prejemnik SY/PY =

var b =YEAR(NOW())-1

Return

CALCULATE(SUM('DW PAKIRANO'[IZDKOL]);FILTER('DW CAS';YEAR('DW CAS'[DATUM])=b||YEAR('DW CAS'[DATUM])=b-1);ALLEXCEPT('DW PAKIRANO';'DW PAKIRANO'[komitent_prejemnik]))

I youd like to get like this: 

 

[v-diye-msft]

Hi @LeaRupnik 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[LeaRupnik]

thanks for the information  @Greg_Deckler and @v-diye-msft  

Now I do the same test which is attached.  

I would like to get just a year 2019 and 2020. 

usp=sharinghttps://drive.google.com/file/d/18ysEkcwUZ50DtafHcIKCMDrbguou8xwI/view?usp=sharing 

Thanks, 

Lea

[LeaRupnik]

thanks for the information. 

Now I do the same test which is attached.  

I would like to get just a year 2019 and 2020. 

usp=sharinghttps://drive.google.com/file/d/18ysEkcwUZ50DtafHcIKCMDrbguou8xwI/view?usp=sharing 

Thanks, 

Lea

[Greg_Deckler]

In general, you use TOTALYTD to get the current year and then use SAMEPERIODLASTYEAR for last year. 

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...