Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Convert Integer/ text to Date format

Hello all,   I have from date and to date columns with data as   From date 010318 050625 090524   i want to convert this to date format, when i change directly in power bi it is giving the w...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    HI Anonymous 

    For your formula, you just need to keep the format of this formula same with your local system.

    For example:

    In my computer, my date format is mm/dd/yyyy

    So I adjust your formula as below:

    FROMDATE1 = MID(MC859A01[FROM DATE],3,2)&"/"&RIGHT(MC859A01[FROM DATE],2)&"/"& LEFT(MC859A01[FROM DATE],2)

    Then change the datatype to date

     

    Regards,

    Lin

JirkaZ's avatar
JirkaZ
Solution Specialist
6 years ago

Anonymous that's exactly what I'm saying. Why wouldn't you be able to use a column created in Power Query in the report/desktop?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

JirkaZ 

#date("yyyy string", "mm string", "dd string")

 

is this any dax function?

 

  • JirkaZ's avatar
    JirkaZ
    Solution Specialist
    6 years ago

    Anonymous No - it's M definition for the new column

    • JirkaZ's avatar
      JirkaZ
      Solution Specialist
      6 years ago

      Anonymous Or you can use this definition of a column (assuming the dates are all after year 2000).

       

       
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        JirkaZ in the from date column few date values are 0. so when i use the given formula its throwing error as value .So, is it possible to replace this error with some blank date