I would like to create a Dax that basically allows me to show both income and expenditure on the same column. Currently, in the data, that column is called “amount”.
So, what I would like to do is to say that if the “Indexed Type” under the CoA table equals to “2. Expenses”, then the amount should be multiplied by minus 1 ( *-1) and otherwise it will be the amount itself. I am hoping that by doing so, I will be able to show the row values as either negative or positive, depending on the Indexed Type, i.e. whether they are income of expenditure.