Forum Discussion
DateValue Year Issue
tkoopmann Have you tried using the below calculated column for Month & Year instead? I found that after changing "YY" to "YYYY" the years were pulled in correctly by the DATEVALUE function.
Month & Year =
FORMAT ( 'dimDate'[Date], "MMM-YYYY" )That works until I change the column to a date type. I'm needing "Date" in the Summarize function to be a date type to tie back to the dimDate table.
*uness there is a more efficient way to average monthly % charged for the year. I could probably use a measure instead of this table altogether.
How is that not working for you? I played around with some sample data and was able to make it work.
I may have changed the wrong Month & Year column.
Adjusting the dimDate Month & Year column to FORMAT ( 'dimDate'[Date], "MMM-YYYY" ) did correct the issue in the summarize table.
Thank you!
Excellent. You're welcome!