Create new column showing concatenated months between two other columns.

[Soundnoobs]

THis may be impossible, I have tried to use Dax CONCATENATEX to just extract this data but I can't do it. 

I have data like this:

I would like to create a new column, which gives me the month names between and including the start date and end date. 

Note: This us UK date format, so day/month/year

For example: 

Is this even possible? 

Thank you

[Pragati11]

Hi @Soundnoobs ,

I got this working by quick transformation in POwer Query and creating a column using DAX in Power BI.

The end result is this: (I have considered sample start and end date)

As the process explanation might be tough to write here, therefore I am attaching the link for a pbix file with the solution.

https://we.tl/t-qDhB0sE6KF

Hope the solution helps.

[Soundnoobs]

Thank you. Yes you were right to consider the start and end date. I made a mistake with the month name. Janyuary should not be there. 

[Pragati11]

HI @Soundnoobs ,

If my solution works please mark it as a solution so that others can benefit from it on the forum.