How to crosstab a table in DAX?

[vibhoryadav23]

Hi, 

I am trying to transpose/crosstab/pivot a table directly in Dax. Is it possible?
Input Table

User	Product	Status
A	Prod 1	Active
A	Prod 2	Inactive
B	Prod 1	Others
B	Prod 2	Active
C	Prod 1	Idle
D	Prod 2	Active

Output table

User	Prod 1	Prod 2
A	Active	Inactive
B	Others	Active
C	Idle
D		Active

Thanks in advance!

[amitchandak]

@vibhoryadav23 , Use matrix visual, User on Row, product on column and max of status as value

[vibhoryadav23]

@amitchandak Thanks for the suggestion and I have already done that but I need a ned table with this format as well.

[PaulDBrown · Accepted solution]

Use:

New Table =
ADDCOLUMNS (
    VALUES ( 'Table'[User] ),
    "Prod1", CALCULATE ( MAX ( 'Table'[Status] ), 'Table'[Product] = "Prod 1" ),
    "Prod2", CALCULATE ( MAX ( 'Table'[Status] ), 'Table'[Product] = "Prod 2" )
)