Forum Discussion
angelikakolacz
Helper I
Helper ISearch with multiple criteria
Hello, I have a table with more than milion rows with data from different customers. I’m looking for a dax formule that gives me the following result (see column output): ACCOUNT NUMBER INVO...
angelikakolaczHelper I
Helper IHi Jihwan_Kim
It's only an example. it doesn't matter which one you take, if the value is unique (not already used before) it's oke.
angelikakolaczHelper I
Helper IHi Jihwan_Kim
what I actually want to see is how many invoices are 0 (credit + debet) on balance if;
- it's the same account number,
- period it's the same
- sum of two invoices is 0.
But it is possible that in my file for a periode are 5 debet invoices and 4 credit invoices (same period). so 8 of them are right, but one is not good. In mine results i want to show that.
I must be able to show my results on row level, hence a new column with output.