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