credit
2 Topics
Handling Debits and Credits in the same table
Hi, I have a table that handles debits/credits in the same column based on a Sales Order No. I can display the SO amount (field called Amount) based on the SO No but also on a filtered level based on another field Applied To Order (which contains the Sales Order No, but will always be a negative value. When I display the Sales Order No, it will only display the full value, not the value minus the credit. I need to figure out a way in DAX for my model display the debit value, minus the credit value, and only if there is a credit value (most of the time, there will not be). I've added a conditional column called Credit/Debit if that helps? Anyone help me out on this or point me in the direction of the DAX function that I should be invoking so I can investigate further? Thank you.Solved3.6KViews0likes10Comments- 1.5KViews0likes1Comment