Forum Discussion
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 | 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
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!
2 Replies
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!