Show same column as two in the table without summarizing

[gvg]

Hi folks,

How do I show same table column as two columns with different filtering in the table visual? For example if I have positive amounts for income, and negative amounts for expense in the same column in the Sales table, how can I show Income in one column and Expense in the second column in the table visual? Trying to add Sales(Amount) column twice into the table visual does not allow me to filter one column as Amount>0 and the other as Amount<0. I also need amounts not summarized. Here's an example:

Initial table                      Expected result

Date    Amount                       Date    Income      Expense
1/1        100                        1/1    100
1/2        -20                        1/2                 -20
1/3        -30                        1/3     80          -30
1/3         80 

[mussaenda]

Can be achieved in power query by adding conditional columns

[gvg]

@mussaenda , but that is a very expensive solution, isn't it ?

[Anonymous]

Income = IF(SUM(Table1[Amount])>=0,SUM(Table1[Amount]),0)

Expenses = IF(SUM(Table1[Amount])<0,SUM(Table1[Amount]),0)

Try creating two measure using DAX and sue them in table.

[gvg]

Thanks @Anonymous , but I need data not summarized.

[Anonymous]

Then add a calculated column use add column (using conditional column) in edit queries.

[gvg]

@Anonymous , no other way to do it? It is expensive to add column to a multimillion row table.

[Anonymous]

You can either add a column(Storage expensive) or create a measure suggested above(computation expensive), thats a trade-off you need to check/test and select 

[gvg]

Well, I think if there is no easy way to do what I need (with no summarization), I am probably better off making two separate table visuals.