This content has been marked as final. Show 4 replies
Say, I have two sets of dates, 2 from different excel file. I wanted to have do this MonthName(Date([Date1])) union with MonthName(Date([Date2])).
Example at excel file A
Example at excel file B
|Item||Sent Out Date|
Such that, my dimension would have June 2015 to December 2015. How can I achieve that?