Forum Discussion

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Calculate MIN, MAX, AVG Values for Particular Month

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