Forum Discussion
Helper IIError trying to add a custom column
Instead of working in the query editor, have you tried adding a calculated column within the data model? I just used Format in that sense in the Data Model by adding the calculated column there as opposed to writing an "M" string in Query Editor. I used a simple Year-Week = [Year]&"-"&FORMAT([WeekNumber],"00") just to make sure FORMAT worked as desired in the datamodel.
Hope this helps.
As an added hint:
I am new to M but I can tell you that all caps throws an error. Only capitilize the F in Format but I don't think Format works anyway.
Not really helpful for this but the all caps thing might come in handy at some point in the future.
Community ChampionFortunately, for those of us new to both DAX and M we usually get the option of which to use. I find DAX easier but am working to learn M. Its a process.
Glad it works for you.
