Barchart with 2 date columns in X-axis

[Rbie]

Hi all,

I have the following data in a table:

ID    In                Out
1     20240101    20240601
2     20000101    20240401
3     20211201    20240127
4     20030714    20231231
etc...

I need a barchart  that shows per year/month the number of ins en outs (the date range should be controlled by a slicer)
something like this

Any idea how to achieve this in powerbi ?

Thanks in advance Rbie

[Rbie]

Thanks @amitchandak , went with your solution from  https://youtu.be/e6Y-l_JtCq4. 

Well explained video, kuddo's to you

[amitchandak · Accepted solution]

@Rbie , Make sure you create date table using these two and then you can have measure approch like

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

or

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

OR Table approach like

https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2