cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Data Type Change

My table has a column of type text. It stores the name of the month abbreviated and current year hyphenated.

Under column tables tab, once I click the field, can I change the Data Type to Date? Or will this cause internal problems?

1 ACCEPTED SOLUTION
Super User

@moe_elbohsaly

It depends on how that column has been used in your model in various calculations. As per your description, it is a text field, the best practice is to creat a dates table and link it to your fact table. you create a dates table with the following"

``````Dates = ADDCOLUMNS(
CALENDAR("01/01/2021","31/12/2021"),
"Month No" , MONTH([Date]),
"Month Name" , FORMAT( [Date] , "Mmmm" ),
"Year" , YEAR([Date]),
"Month Year No" , (YEAR([Date]) * 100) + MONTH	([Date]),
"Month Year" , FORMAT( [Date] , "Mmm yyyy"),
"Quarter" , QUARTER([Date]),
"Year Qtr" , FORMAT( [Date] , "YYYY \QQ"),
"Week Day" , WEEKDAY([Date],2),
"Week" , FORMAT( [Date] , "Dddd" )

)``````

.

Did I answer your question? Mark my post as a solution! and hit thumbs up
2 REPLIES 2
Super User

@moe_elbohsaly

It depends on how that column has been used in your model in various calculations. As per your description, it is a text field, the best practice is to creat a dates table and link it to your fact table. you create a dates table with the following"

``````Dates = ADDCOLUMNS(
CALENDAR("01/01/2021","31/12/2021"),
"Month No" , MONTH([Date]),
"Month Name" , FORMAT( [Date] , "Mmmm" ),
"Year" , YEAR([Date]),
"Month Year No" , (YEAR([Date]) * 100) + MONTH	([Date]),
"Month Year" , FORMAT( [Date] , "Mmm yyyy"),
"Quarter" , QUARTER([Date]),
"Year Qtr" , FORMAT( [Date] , "YYYY \QQ"),
"Week Day" , WEEKDAY([Date],2),
"Week" , FORMAT( [Date] , "Dddd" )

)``````

.

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper I

Thanks @Fowmy ! I managed to do a DAX namely FORMAT([text_column],"MMM-YYYY") since my text contains the month name abbreviated and current year hyphenated.