P&L Finance report

Anonymous 

I'm not too sure what you mean. If your expenses are -ve values and you want to display them as such all you have to do is change the measure to:

Difference = 
VAR Rev = CALCULATE([Sum of Values], FILTER(Table, Table [Acct Type] = "Revenue")) 
VAR Exp = CALCULATE([Sum of Values], FILTER(Table, Table [Acct Type] = "Expense")) 
RETURN
Rev + Exp

Notice how the "return" now has a "+" 

If, however, your Expenses are -ve values, but you want to display them as +ve values you have 2 options:

1) Create a new measure and multiply the [Sum of Expenses] *-1. In this case the value itself changes to +ve, so the [Difference] measure must remain Rev - Exp

2) Simply change the display format for the original measure: you can change the display format for the measure under the modeling view. Select the measure in the model view, go to properties, Formatting and select custom. The second expression in the string corresponds to the -ve values. Change it so that it is the same as the +ve values string.

 This will ONLY change the display format; the value actually remains -ve (see depiction below: the measure [Check formatted values] is multiplying the Formatted measure *1), so the [Difference] measure must be Rev + Exp

Here is depiction of the options:

As regards the order of the rows, the best way to do this is to include an "Order" column in the Dimension tables for "Revenue" and "Expenses":

1) This is easy to do in Power Query: create a conditional column in each dimension table and establish the order value for each of the rows.
2) Alternatively you can do this in Excel by recreating the dimension tables in Excel, write the order values for each row, import the tables to the model to become your dimension tables and establish a one-to-many relationship with the fact tables).

Then go to the tabel view for the dimensions, select the "Revenue" and "Expense" columns, and use the function in the ribbon "Sort column by" and choose the "Order" column. 

Let us know if you get stuck!