Forum Discussion
Using Measure to create month/year calculation, works in one query but not the other
Anonymous
Please see the image on how I did it. The column in the formula should in in date format for this to work.
I tried making a custom column with basic just MonthName, it says no syntax errors but you can see upon saving it, the column is showing ERROR. What am I missing, I confirmed the referenced field is date/time data type.
I found the issue, the syntax was not correct even though the custom column dialog box says no errors detected. I was missing the parenthesis in the formula. The correct formula is in my posting #4 is:
Date.MonthName([created_at_PST])
Once I fixed it, everything works now. 😊 Thanks VasTg, your final posting helped me get what I need and it's all working, I knew I was missing something simple:
Date.MonthName([created_at_PST]) & " " & Text.From(Date.Year([created_at_PST]))