Assuming columns A and B are one dataset and columns C and D are another, we should transform 4 columns into just 3 - Date, Units and Forecast. This can happen by Merging the 2 datasets by the Date column in the Query Editor.
Thank you very much for your time and help , this works great! i really appreciate it . Your solution reflects how an expert you are in Power BI congratulations!! Thanks Again Pat and congratulations on being such a nice and supportive person and expert user.