Forum Discussion
gvg
Post Prodigy
Post ProdigyShow same column as two in the table without summarizing
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...
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.
gvgPost Prodigy
Post ProdigyThanks Anonymous , but I need data not summarized.
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.
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