I have several calculations that I want to perform. My data looks like this at the moment:
The first thing that I want is to create a Custom Column using Edit Queries. I want a Product count per product (Products being Cant_TC / Cant_CC / Cant_CA). Afterwards, I would like a measure that gives me the average product count per client. I did it this way in Excel:
In the end, the goal is to get something like this:
It is important to know that this calculations will change over time so it must include some kind of client and time measure (FechaCarga and Client).