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.
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?
Anonymous
Please see the image on how I did it. The column in the formula should in in date format for this to work.