Date format MMMMMM YYYY from text (english)

Hi Pedro77000 

First, we should know that a column like "January 2019" can't be changed to "date" type.

However, we can format the column as "January 2019" and still keep its date type via Modeling->date format

Assume you have data below,

Instead of creating text date column, create relationship below

If you want to format the date column like "January 2019", you could add a calculated column like

FORMAT([Date],"mmmm yyyy")

Then create measures in main table

current = SUM('Table'[value])

previous month = CALCULATE([current],DATEADD('date'[Date],-1,MONTH))

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.