Create a new table based on Date data

[maTank]

I have a dataset, with various statuses and the dates they changed
sample (fake) data:

Worker	Status	Date Updated
Arin	Employed	12-03-23
Arin	Unemployed	19-06-23
Arin	Employed	25-11-23
Brian	Employed	01-01-23
Brian	Retired	20-10-23
Dan	Employed	03-02-23
Dan	Unemployed	29-05-23
Dan	Employed	07-07-23
Dan	Retired	19-09-23

and what I want to create is a summary of the worker statuses in all months of the year:

Worker

Jan-23

Feb-23

Mar-23

Apr-23

May-23

Jun-23

Jul-23

Aug-23

Sep-23

Oct-23

Nov-23

Dec-23

Arin

Employed

Employed

Employed

Unemployed

Unemployed

Unemployed

Unemployed

Unemployed

Employed

Employed

Brian

Employed

Employed

Employed

Employed

Employed

Employed

Employed

Employed

Employed

Retired

Retired

Retired

Dan

Employed

Employed

Employed

Unemployed

Unemployed

Employed

Employed

Retired

Retired

Retired

Retired

please help

[miTutorials · Accepted solution]

I added a Matrix visual with your sample data and this is what it looks like.

You can add the fields like the below. But remember it's only going to pull in the First status of that date by the worker.

Best regards,

Ismail | MiTutorials

 MiTutorials on YouTube Explore over 200+ Power BI tutorials and enhance your skills!

[maTank]

Ok, thanks anyway...