Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

DAX Consultation

Hello People, I hope it is going well. I'm testing some functions for a personal project and I'm having problems with a logic. I have a Sales table that contains employee code, date, values, and...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Hola @Syndicate_Admin

Here is the link to the excel mockup: https://www.transfernow.net/dl/20240802i4CwOQFc


The idea would be to have a table of employees with sales for the period, something like this, in this case as it has a duration of 11 it would be an avg of 4-6 (as a duration greater than 6 then that period divided 3, the same with the period 7-9 and in the period 10-12 there add the values but dividing by 2 since it does not have 12 duration.

NumberEmployee CodeStart DateDuration0-3
months		4-6
months		7-9
months		10-12
months
Juan Antonio Andujar120/06/202311015812,570005625

Any other questions you can ask me. I hope you understand.

Thank you very much in advance!