The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
This is the way the data is pulled from a particular system.
First Name | Last Name | Date of Appointment | Status | Status Date |
Jane | Smith | 01/02/2000 | XYZ | 05/02/2000 |
Jane | Smith | 02/02/2000 | XYZ | 05/02/2000 |
Jane | Smith | 04/02/2000 | XYZ | 05/02/2000 |
Is there a way to find the total number of times Jane Smith has come in for an appointment?
Is there a way to calculate the number of days it took for Jane Smith to reach status XYZ from her last appointment (viz the last row for a given person),
ideally both of these questions would be answered in the same visualization?
Any help would be great.
Solved! Go to Solution.
Hey @iwnyk ,
I'm not sure what data visualization you imagine. Can you create a scribble?
Next to that, you should consider creating a dimension table that contains the "customer" and create a column in your existing table that contains the "customer" Jane Smith in a single column. It's not possible to create a data visualization where the axis label "Jane Smith" is derived from two columns, except for hierarchical labels.
Regards,
Tom
Hey @iwnyk ,
I'm not sure what data visualization you imagine. Can you create a scribble?
Next to that, you should consider creating a dimension table that contains the "customer" and create a column in your existing table that contains the "customer" Jane Smith in a single column. It's not possible to create a data visualization where the axis label "Jane Smith" is derived from two columns, except for hierarchical labels.
Regards,
Tom
User | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
28 |
User | Count |
---|---|
106 | |
98 | |
55 | |
49 | |
48 |