Format for Year in Date Table

Power BI Data Model
1

I’ve noticed that when a date is split into a year column, that most seem to format the year (e.g. 2019, 2018) as text instead as a whole number.

Does it make any difference in the data models if it is formatted as a whole number?

Regards, Sergei

2

Just depends really I think.

Most of the time probably doesn’t matter, but say for example you have a year column in a fact table, you probably want to have them setup the same.

Thanks
Sam

1 Like