Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
iwnyk
Regular Visitor

Calculating difference between dates in the same visualization

This is the way the data is pulled from a particular system.

 

First NameLast NameDate of AppointmentStatusStatus Date
JaneSmith01/02/2000XYZ05/02/2000
JaneSmith02/02/2000XYZ05/02/2000
JaneSmith04/02/2000XYZ05/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.

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

1 REPLY 1
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.