Transform .vs. DAX for a Datetime column I want to convert into hierarchy

[Francisco_G_Cal]

I have a DateTime column in a table, in format "dd/mm/yyyy hh:mm:ss", loaded as DirectQuery, whith about 2 million rows. Is part of a model with other tables.

I want to create a date hierarchy (year, mont, day, week, hour... and so on) for my model.

Wich is a better solution, to TRANSFORM the table with M (creating Year, Month, Day, hour... and so on), or create the measures directly with DAX from the original datetime column? (as far as I can see, using M to extract Date and Time is not permited in DirectQuery, only import)

Thanks!

[Greg_Deckler]

@Francisco_G_Cal Generally you want to do that kind of transformation in M. Also, it would be best practice to actually have a date table with all of those transformations in it and then relate it to your fact table.