Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Change Date format to YYYYMM

Hi,   I have a date column in YYYYMMDD format, when I import to Power BI, the Data Type is Text.   I need to convert to Data Type "Date" and Date Format -> YYYYMM.    In the Modeling tab, the D...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    In the Date Table, write this calculated column formula

     

    =FORMAT('Date'[Date],"YYYYMM")

     

    In the slier, drag this column.

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

In the Date Table, write this calculated column formula

 

=FORMAT('Date'[Date],"YYYYMM")

 

In the slier, drag this column.

 

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello Ashish, 

I have similar kind of problem. 

 

When I use above solution, then I am not able to convert "YYYYMM" format to Date. It shows as text. I want this format to be converted to date as I am performing time intelligence calculations on it.

 

Do you know anyother solution for it ?

 

Thank you for help. 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Try this calculated column formula

    =date(left(Data[Date],4),right(Data[Date],2),1)