Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
@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.
User | Count |
---|---|
94 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |