Forum Discussion
Coryanthony
Helper III
Helper IIIHelp with measure
I want to filter out debit and credits from table, either in power query or dax formula (both if all possible).
Any suggestions? If the transaction was refunded entirely (Yellow highlight), i want to filter it off the report. If it was a partial refund (green highlight) or not refunded, i want to see it.
Please help.
1 Reply
- amitchandak
Super User
Coryanthony , create a new column and use that
new col =
var _cnt = countx(filter(Table, [employee ID] = earlier([employee ID] ) && [vendor] = earlier([vendor] ) && [Transaction Amount] = -1* earlier([Transaction Amount] )), [Transaction Amount])
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820sreturn if(isbalnk(_cnt), 0,1)
