Forum Discussion

UB400's avatar
UB400
Regular Visitor
8 years ago
Solved

Splitting Column containing Debits and Credits

Hi all, I'm new to PowerBi and am currently working through the tutorials. I have a Table that has a Debit/Credit Column with a Text value of C or D and another column which contains the related a...
  • shebr's avatar
    shebr
    8 years ago

    Hi UB400

     

    In your query designer, (see image below) do the following:

     

    1. Highlight your Credit/Debit column

    2. Click on 'Pivot' in the ribbon above

    3. Select 'Amount' in the values options

    4. Click OK.

     

    You should have the data in your required format. (See image 2) 

     

    Let me know how you get on.

     

    Thanks

     

    shebr

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

I would do this in the Query Editor and add two Conditional Columns. Basically for Debit column, if the Debit/Credit column is "Debit", then Amount, otherwise null.