Forum Discussion
Income Statement Matrix
Hello, I am having issues building an income statement using the Matrix table. I have provided sample data below and an end-goal picture. I am trying to achieve the below: 1) TOTAL REVENUE as a s...
txpower , You need to create sort column and then use it. example
A new column in the table
Switch( True(),
[OBJ Account] ="Wages" ,1,
[OBJ Account] ="Material" ,2,
//// Keep on adding
)
Mark it as the sort column
Refer steps :https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Hi, I am not following. Do you have an example work you can attach?
