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.
Yes I'm creating a measure and referencing a date column to get month as well as year from it. I am selecting the right table. What is confusing is that it works in one table but not the other? Also, why is when I'm in the data entry stage, I don't see list of all my available fields? It only shows 3 fields when I have 15 fields? It worked fine when I built the first one.
Thanks!
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.
- VasTg
Memorable Member
Anonymous
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.
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]))