Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date formating

Hello   I have data table with Date column in format "20200831" <- today. I created a Date hierarchy table but I need to add a measure so it would show the date in the same way as in my Date colum...
  • FarhanAhmed's avatar
    6 years ago

    you can create a column in date table and join it with your data table.

     

    DtKey = FORMAT('Table'[Dt],"YYYYMMDD")

     

     

  • lkalawski's avatar
    6 years ago

    Hi Anonymous ,

     

    You need to add calculated column: 

    Date Formatted = Format('Table (2)'[Date], "YYYYMMDD")



    _______________
    If I helped, please accept the solution and give kudos! 😀