What chart or graph do i use to compare time between dates?

Question

I have the following data:&nbsp;Created DateInvoiced DateRegion&nbsp;I want to chart out somethng like&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;---------------------------------------created date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;---------------------------------------Invoice Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RegionIn a line chart.&nbsp; Can this be done?&nbsp;&nbsp;&nbsp;Cant figure out how to bring in the data&nbsp;The lines will fluctuate depending on days between invoice date and created date.&nbsp;

amitchandak · Accepted Answer

Rocky_Brown , With a common date table, You can create measures that work on create date and Invoice date. Use userelationship for inactive dates&nbsp;
&nbsp;
example: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
&nbsp;
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Forum Discussion

What chart or graph do i use to compare time between dates?

2 Replies

Related content

Comparing Dates

Count of end dates compared to begin date

Trouble comparing dates with todays date

Comparing Date Counts

Compare Dates