I want to convert text to date

[norwor]

Output: September 2023

Cannot convert value " of type Text to type Date.

How can i convert this to date

Thank you

[Ahmedx]

pls try DATEVALUE :

Intake Year = DATEVALUE(IF(........))

[norwor]

Thanks for your respond but it still error

[Ahmedx]

why do you have two month columns and two year columns
what do you want to end up with

[Ahmedx]

write what is wrong , what is error
Or Share sample pbix file to help you

[norwor]

Same context - Cannot convert value " of type Text to type Date.

[Ahmedx]

why do you repeat the month and the year twice in a measure?
is this wrong or do you want to get a range or what?

[norwor]

If country = "AU" year-1 else the same date as first that what i need

[Ahmedx]

If (country = "AU" , DATE('table' [year]-1, 'table' [MONTH],1) , DATE('table' [year], 'table' [MONTH],1))