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