Date formating

[Anonymous]

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 column in data table so I could make a relationship between them. 

[FarhanAhmed · Accepted solution]

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

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

[amitchandak]

@Anonymous , you can create this format in date using

Day key = format([Date],"YYYYMMDD")

Day key = year([Date])*10000 + month([Date])*100 +day([Date])

Or you can create date from this format

date = date(left([Day key],4) , mid([Day key],5,2), right([Day key],2))

20200831

[lkalawski · Accepted solution]

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! 😀

[FarhanAhmed · Accepted solution]

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

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