topic Total rate per cod and per month in DAX Commands and Tips

Total rate per cod and per month

Goudi — Wed, 26 Jul 2023 15:41:59 GMT

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!!!

Re: Total rate per cod and per month

v-zhangti — Fri, 28 Jul 2023 02:37:23 GMT

Hi, Goudi

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

Best Regards

Re: Total rate per cod and per month

Goudi — Tue, 01 Aug 2023 07:44:15 GMT

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,