Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Get month and year from date

Hi,   I want to get the month and year in format January 2019 etc from my date column. I tried the below format but i get this error- FORMAT ( 'TABLENAME'[Date], "MMMYY" ) Function 'FORMAT' is no...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago
Add it to Dimension table or create a measure? Could you help with this
sgsukumaran's avatar
sgsukumaran
Icon for Resolver II rankResolver II
7 years ago

I would add it to the Dimension table, redeploy and process.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I also have a column with info like 2019-01 ,2019-02 etc . I was thinking if i could convert it to 2019 January etc that could do it. Is that possible in this model?