Text to Date

[felix-chong]

Hi there

I am new to BI and have the below format of table in Data.

Sales	FY	FM
500	2021	May
600	2021	Jun

skipped 50000 rows

System doesn't read it as date and i am struggled to compare. Could anyone advise please?

Thanks

F

[Anonymous · Accepted solution]

Hi @felix-chong 

You can use DAX or M, here is a column in DAX

Date = DATEVALUE('Table'[FY]&"/"&'Table'[FM]&"/"&"1")

And one in M

Date.From( "1."&[FM] &"."&Text.From([FY]))

[Anonymous · Accepted solution]

Hi @felix-chong 

You can use DAX or M, here is a column in DAX

Date = DATEVALUE('Table'[FY]&"/"&'Table'[FM]&"/"&"1")

And one in M

Date.From( "1."&[FM] &"."&Text.From([FY]))

[felix-chong · Accepted solution]

Hi Vera_33

Thanks for the suggestions. 

I tired and the following errors come up.How could i fix it please?

Thanks

F

[Anonymous]

Hi @felix-chong 

You need to change Table to your real table name...