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
7 years ago

Hi Ashish,

 

Thanks, that worked.

 

But I had a question since we are formatting the date as a Text now using the FORMAT function, will it impact the relationship or calculations.

 

Eg: User selects 201902 i.e. Feb 2019 in the dropdown, will the measures and calculated columns work as usual? I'm clarifying because 201902 is of Text format whereas the calculations are based on date selected by end user.

 

Please correct me if I am understanding incorrectly.

 

Thanks,

Vishy

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

    You are welcome.

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

    Hi,

     

    This is another column you have created in the Calendar Table.  Since the Date column stays intact and that is the column you hae built the relationship to, all measures and columns will work as expected.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you Ashish for your time and inputs.