Forum Discussion
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...
sgsukumaran
Resolver II
Resolver IIAnonymous - From your screenshots it appears that you are using direct query model. If so you cannot add columns at this time. You can only create measures. You are tryin to accomplish row context and the best way to do this is to add your logic to your model.
kcantor
Community Champion
Community Championsgsukumaran That is a good catch. Kudos to you!