Converting Month Names in short text to Date
I have to identical tables with Column named month which has short text values of month names (Jan, Feb, Mar.....etc). I need to convert it to date. I am using below formula which works for one table but for other it throws an error. Can anyone please explain what I am doing wrong or any better alternatives. Formula: Month Seq = DATEVALUE(FORMAT( "1-" & FY20[Month] & "-" & FY20[Year], "dd-mmm-yy" )) Error:Filter month year column to exclude future dates from today
I have a dates key table that runs from Jan 2018 - Jan 2021. I have a month year column (Text Format): Month Year = FORMAT('DimDate'[DateS],"MMM YYYY") However it pulls in all dates in the dates key range: Is there a way to exclude future dates from: FORMAT('DimDate'[DateS],"MMM YYYY"),<=TODAY() Thanks in advance
