I am a bit of a newbie when it comes to Powerpivot and a total novice when it comes to forums but have come across an issue I cannot solve on my own and need help.
I have a transaction table, which includes the date the transactions was created and the date it is effective from, along with additional relevant info. The data is coming from a CSV file of which I have no control.
In my data there can be occasions when you summarize the data, that the true count of the transaction is 0 because the total sum of the transaction amount is 0. There could be two or more relevant transactions that cause this to apply. E.g.
In this example I really don't want any of these transactions to be included in any count, as collectively they negate each other. This is based on the shared characteristics of CustomerID, ProductID, Effective Date, Transaction Type. Hence the UniqueID calculated column. There are 2 true transactions but as both sum to 0 I really need these to be ignored no matter how they are viewed. I have yet to find a way to achieve this especially if the data is being viewed by the month it was created, as in both instances they both show up i.e. one for September and one for October. Also same applies when viewed by Created by.
Can anyone assist as I just can't figure it out. Here's hoping my question makes sense, please let me know if you need more info or further clarification.
Many thanks in advance.
I have a transaction table, which includes the date the transactions was created and the date it is effective from, along with additional relevant info. The data is coming from a CSV file of which I have no control.
In my data there can be occasions when you summarize the data, that the true count of the transaction is 0 because the total sum of the transaction amount is 0. There could be two or more relevant transactions that cause this to apply. E.g.
In this example I really don't want any of these transactions to be included in any count, as collectively they negate each other. This is based on the shared characteristics of CustomerID, ProductID, Effective Date, Transaction Type. Hence the UniqueID calculated column. There are 2 true transactions but as both sum to 0 I really need these to be ignored no matter how they are viewed. I have yet to find a way to achieve this especially if the data is being viewed by the month it was created, as in both instances they both show up i.e. one for September and one for October. Also same applies when viewed by Created by.
Can anyone assist as I just can't figure it out. Here's hoping my question makes sense, please let me know if you need more info or further clarification.
Many thanks in advance.
