Forum Discussion
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...
you can create a column in date table and join it with your data table.
DtKey = FORMAT('Table'[Dt],"YYYYMMDD")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! 😀
amitchandak
Super User
Super UserAnonymous , 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