Creating a Date Column with only Month and Year

Power Query
2

Hi @chris786,

You can use Date.From for that job, see below.
Note that both Year and Month are text strings, if that’s not the case you’ll have to turn the Year into a text string by wrapping Text.From around it.

image

Rick de Groot recently did an excellent post on How to Extract Dates From Text String in Power Query please check that out if you want to learn more.

I hope this is helpful