Calculation average of a property per year

[Steffi1182]

Dear all,

I have a really easy data set including results from single samples, single properties but sometimes taken in the same year.

Now I want to calculate e.g. the yearly average, yearly min or yearly max of, let us say density or CFPP from all samples taken in 2015. How can I do that?

Thanks for your feedback

[amitchandak]

@Steffi1182 , You can try like this . Better to have separate Year/date table

This Year = CALCULATE(Average('Table'[Col]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))

Diff = Max(Table[Col]) -[This Year])

[Steffi1182]

Hey, it das not really work. Now I have a wrong syntax. Can you describe step by step? Should I create a date table first? I have no expierance on Power BI and have to learn. Thank you

[amitchandak]

@Steffi1182 , seem like you do not have date table. Use the Data table in that place.

[Anonymous]

Of course, you have to have a Date table in your model. Please refer to this: https://docs.microsoft.com/en-us/power-bi/guidance/model-date-tables