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.
Memorable MemberAnonymous
Click on the cell where it shows error to see the actual error.
Are you trying to append month and Year?What is the final requirement
Thanks, I clicked on error and it shows:
"Expression.Error: We cannot apply field access to the type Function.
Details:
Value=[Function]
Key=reversed_at_PST"Yes, my final requirement is to create a concationated field showing "Month & Year" . For example: if my field: reversed_at_PST has a date of 1/4/20 then the result of the formulate would show: "January 2020".
As I mentioned, it working in my first query/table but not in the 2nd one. Is there something wonky I have on that specific date field that is preventing this?
- VasTg
Anonymous
Please see the image on how I did it. The column in the formula should in in date format for this to work.