Create multiple columns from data in single column

Hi mm44 

Under the Home tab in PBI Desktop click the transform data button. From here click on the Reorder tab so that it is hightlighted.

In the transform tab click pivot column and set the value to TypeQty. Click advanced options and set the aggregate value function to Don't Aggregate. 

Your table will then appear as you want it.

*Update*

I forgot to mention, if you wish to replace the null values with 0.

Select all three columns, right click on one of them and click replace values. Value to find = null and replace with = 0

Hi mm44 

You can create a new table with this DAX expression:

Table 2 = 
SUMMARIZE (
    'Table',
    'Table'[Item],
    'Table'[Warehouse],
    "Standard",
        CALCULATE ( SUM ( 'Table'[Qty] ), 'Table'[Reorder Type] = "Standard" ) + 0,
    "Customer",
        CALCULATE ( SUM ( 'Table'[Qty] ), 'Table'[Reorder Type] = "Customer" ) + 0,
    "Sales",
        CALCULATE ( SUM ( 'Table'[Qty] ), 'Table'[Reorder Type] = "Sales" ) + 0
)

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube