Forum Discussion
Solved
DateValue Year Issue
I'm having issues with DATEVALUE pulling the correct year. It's pulling 2024 for all date years. This functioned correctly prior to the new year. Examples below. Month & Year is a text column, pu...
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.
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!