Forum Discussion

felix-chong's avatar
felix-chong
New Member
5 years ago
Solved

Text to Date

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 str...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
    felix-chong
    5 years ago

    Hi Vera_33

    Thanks for the suggestions. 

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

     

    Thanks

    F

felix-chong's avatar
felix-chong
New Member
5 years ago

Hi Vera_33

Thanks for the suggestions. 

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

 

Thanks

F

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi felix-chong 

 

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