DAX to fetch values from a column based on filter of another column

[sandyn-2303]

I am new to Power BI and DAX. I need help with the below.

I have a table in my input like this -

Tutor	Subjects	Status
John	Chemistry	Complete
Mike	Biology	In Progress
Stella	Physics	Not Started
Mike	Economics	Not Started
Mike	Algebra	In Progress
Stella	Geometry	In Progress
John	Economics	Complete

I need to create a visual table something like this. Is there a way I can create a measure to fetch the Status of Subjects that each Tutor handles?

Subjects	Mike	Stella	John
Chemistry			Complete
Biology	In Progress
Physics		Not Started
Economics	Not Started
Algebra	In Progress
Geometry		In Progress
Economics			Complete

Thanks,

Sandy

[amitchandak · Accepted solution]

@sandyn-2303 , Create a matrix with the subject on row, Tutor on column, and status on values

means max(Table[status]) on values , you can min too