Compare two columns of dates from the same table

[Anonymous]

Hello everyone

I need help!!! I have a table with three columns: id, entry date and closing date. I want to graph the date columns in a bar chart, showing me month by month how many records were entered and how many were closed. I don't know what to put on the x-axis.

I made a table with the data and it shows me the total per month and I would like to do the same with the graph.

I would be very grateful for your help,

Best regards

Diana

[amitchandak · Accepted solution]

@Anonymous , refer to my blog on similar topics, see if that can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

or the video  https://www.youtube.com/watch?v=e6Y-l_JtCq4

[Anonymous]

Thank you, it help me a lot !!! But you know how can i do the same with dates that include hour. Because the way you show it is with dates that are without hours.