Merging date columns

[Anonymous]

Hello,

I have a data sheet that has all my date columns.  I have date columns:

KM1 Forecast Date, KM2 Forecast Date, KM3 Forecast Date, KM3.1 Forecast Date, KM3.2 Forecast Date and RM1 Forecast Date.

Within these dates wer have values so I want to have one column for all these dates combined which shows as months.

I then want to pull values into each of the months.

Please see attahced images.

Billy

I've tried to do this but the values don't show properly

[amitchandak]

@Anonymous , You can join all of these dates with a common date table's date. Only one join will be active. Others are inactive. You can activate using the userelationship

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-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi