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.
Memorable MemberAnonymous
Are you creating a calculated column? It doesn't look like a measure unless you are concatenating two measures.
Are you creating that in a right table?
Edit: You should wrap them with one of the aggregated function.
MIN( 'All_AMS_Reversals'[reversed_at_PST].[Month]) & " " & MIN('All_AMS_Reversals'[reversed_at_PST].[Year])
Maybe you want to create "New Column" instead of "New Measure"?
If it helps, mark it as a solution
Kudos are nice too
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
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