Forum Discussion

RvdHeijden's avatar
RvdHeijden
Icon for Post Prodigy rankPost Prodigy
9 years ago
Solved

Transform a date to year-month

I have a question and i need your help.   I have a column with dates in the following format 3-2-2017 07:49:00 and i want to transform that to a year-weeknumber for example 2017-05.   My formula ...
Need Help
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

RvdHeijden

Try this instead

Year-Mon = FORMAT('Table'[Date], "YYYY-MM")

Good Luck! :smileyhappy:

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How is this supposed to be used in the context of the query? 

I tried adding this to a Table.AddColumn() clause as the last argument and it doesnt recognised FORMAT, What am I missing?