Forum Discussion

LauraBueno's avatar
LauraBueno
Icon for Helper III rankHelper III
4 years ago
Solved

Date format in power Bi Desktop

Hi all,   I have data table in power bi Desktop that has a column with date information and the format is text. I am trying to convert it to Date format however when I try to change the format it c...
Need Help
  • VIJAYKUMART's avatar
    VIJAYKUMART
    4 years ago

    step 1:

    Step 2:

     

     

    then change data type in power query. Hope it helps

     

Adescrit's avatar
Adescrit
Icon for Impactful Individual rankImpactful Individual
4 years ago

Try this:

 

Date = 
VAR __Day = VALUE( LEFT( 'Table'[Text], 2) )
VAR __Month = VALUE( MID( 'Table'[Text], 4, 2))
VAR __Year = VALUE( RIGHT( 'Table'[Text] , 4) )

RETURN
    DATE( __Year, __Month, __Day )