Total rate per cod and per month

[Goudi]

Hello,
I've been working on a measure for days and I'm not able to get it out. I need to calculate the total rate per cod and per month. Can someone please help me? This is my table:

Thanks!!!

[Goudi]

Hi @v-zhangti,

Thank you! The example of what I would like to get (based on the example) is:

Total January for cod CRO = 1908.36 (3 x 336.12) + (4 x 225)
Total January for cod WSL = 112.25 (189.25 x 6)
Total February for cod CRO = 1135.5 (6 x 189.25)

Total March for cod ERT = 3434.13 (287.21 x 3) + (10 x 257.25)

Thanks,

[v-zhangti]

Hi, @Goudi 

Based on the data you provided, give an example of the output you would expect.

Best Regards