Forum Discussion
Cannot move calculated column in matrix
hi, Anonymous
It couldn't be achieved that move the column place after [total] column in power bi for now. It could only be adjusted in "attribute" area.
and for second question, The calculate column couldn't appear in Edit Queries. Because Calculate column is based on DAX language and data model, but column in Edit Queries is based on M language and data soure.
https://radacad.com/m-or-dax-that-is-the-question
If you still want to pivot it, you could use same logic create a custom column in edit queries then pivot.
Best Regards,
Lin
Super UserHi. I think that you will complicate your model for this. I usually say no to this kind of things, because you allready have what you need there.
Anyway, the only way to have that value at the end, is if you remove all data columns from the matrix and add measures for any columns you want. E.g. Measure for F values, R values... for Status total and finally for Outstanding Quantity.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.