Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Create a new table based on Date data

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 2...
  • miTutorials's avatar
    2 years ago

    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!