Forum Discussion
Time formating for Data Model cannot be changed when using external data set
Hi Anonymous ,
Is it the "Created Date" in the non-DateDim that is showing as DateTime? And, in Power Query editor, when you select that column for "Created Date", are you saying it does not let you change that to "Date"? Is the non-DateDim table DirectQuery or is it Import?
Hi collinq
The "Created Date" column is calculated column and it is also set to Date type
As you see above all the fields involved are of date type, and i guess it is a feature of data model editor that you can go in and chose the formating for the field/relation for some reason by default it is date/time.
Anonymous
Sorry, but why did you add a new column date (Created date) from an already existing column (Created_timestamp)!?
Its because I wanted to use additional date table, but on the other hand I got alot of visuals using timestamp field with date hierarchy feature. If I would use timestamp field as an foregin key for date table it cannot be used anymore as a date hierarchy field.
Of course in the long run I could switch to the date table, but so far I'm having issues with getting it to work for one visual.
