In Brazil, when we make a sale and a purchase of the same stock on the same day, this operation is called "Day Trade", and it has different characteristics.
Therefore, I need these operations not to influence the others.
The problem exists when for example:
I already have a long position for an stock, and the other day I make a "Day Trade". Information about the existing long position should be maintained without the influence of Day Trade.
I have included a column from the Trans table, where I put the acronym "DT" in the purchase operation and the "Day Trade" sale operation.
How could I insert this filter into the measurements? What measures?