Calculate MIN, MAX, AVG Values for Particular Month

[pawelj795]

Hi,
I have a model with unit COGS data of my products.
I want to calculate Min, Max, and Average Unit COGS for every month.

Important note!
I want these measures for every month, I mean it would be different values for January, February, etc.

The desired result should look like below:

Sample data:

https://drive.google.com/file/d/1qw3NvL-Zi-LPkldy43FyI-iir6oPLohp/view?usp=sharing

[Jihwan_Kim · Accepted solution]

Link to the sample PBIX file