Forum Discussion

jpt1228's avatar
jpt1228
Icon for Responsive Resident rankResponsive Resident
8 years ago
Solved

Convert YYYYMM to date

Hello, I have searched all over and I see many folks have the opposite issue.   I have a date column that is YYYYMM and I need to convert it into a date the date table can recognize. When I add a c...
Need Help
  • jpt1228's avatar
    jpt1228
    8 years ago

    Figured it out - Converted the YYYYMM Column to text and then added new column and used this code.

    =Date.FromText(
Text.Range([Input Date as Sting], 0,4) & "-"  &
Text.Range([Input Date as Sting], 4,2)
    )

     

Decal's avatar
Decal
Icon for Helper I rankHelper I
2 years ago

I would like to see how to do it in dax when coming from text 

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

Hi,

This calculated column formula will work

Date = 1*("1/"&right(Data[YYYYMM],2)&"/"&LEFT(Data[YYYYMM],4))

Hope this helps.

  • Decal's avatar
    Decal
    Icon for Helper I rankHelper I
    2 years ago

    This converts is to a 5 digit number (e.g., 44197 for 2021-01).  I need a date.  Power BI won't let me format 44197 as a date

    • Decal's avatar
      Decal
      Icon for Helper I rankHelper I
      2 years ago

      It worked to use
      Date = 
      DATE ( LEFT([YYYYMM field]),4),RIGHT([YYYYMM field],2),1)

       

      Thank you all for the help