Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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!
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!
Ok, thanks anyway...