IF then statement and extracting date together

[Anonymous]

Hi,

I have a data set where one ofthe columns is created_date(mm/dd/yyyy). I want to create another column where if the created_date is before 04/10 it populates "Historic" otherwise it populates the month and year from the created_date column. 

Is it possible to do it? 

Any help on this is much appreciated.

[amitchandak]

@Anonymous , Create a new column like

if([Created_date] < date(2020,04,10),"Historic" format([Created_date],"mm/yyyy"))

[Anonymous]

Thanks for your response! However, this doesnt seem to work . It shows an error RightParen expected.

[Anonymous]

HI @Anonymous 

Us teh below code 

IF(table([CREATED_DATE])<DATE(2020,04,10),"Historic", FORMAT([CREATED_DATE],"MM/YYYY"))

[harshnathani · Accepted solution]

Hi @Anonymous ,

You are creating a column in Power Query while the above code is in DAX, this is the reson you are getting the error RightParen expected.

Incase you want to do it in M Language or Power Query

Column = if [Date] < #date(2020, 4, 20) then "Historic" else (Date.MonthName([Date]) & " " & Text.From(Date.Year([Date]))))

Replace [Date] --> with Created_Date

 In DAX

Column = IF(Dates[Date] < DATE(2020,04,10),"Historic", FORMAT(Dates[Date],"mm/yyyy"))

replace Dates --> with your table name

replace [Date] --> with your column name

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)