Forum Discussion
Date Hierarchy Needed
Hi, I need to create a Calculated Column using a date column by multiple & statements to create a unique key in the Fact Table. However I do not need the time portion of the date table. The probl...
Hi Anonymous ,
You may try
New Column = DATEVALUE([DATE])New Column = DATE(YEAR([DATE]),MONTH([DATE]),DAY([DATE]))If your DATE column is Date/Time type, the new column will be Date/Time as well.
So that you could follow Samarth_18 's suggestion to manually change the new column 's type to Date. Or go to Column Tools --> Change Data type:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Samarth_18
Community Champion
Community ChampionHi Anonymous ,
Since its a direct query you will not able to create a custom column so you can change your date column data type from date/time to date from the Model window like below:-
And for enabling date hierarchy you need to enable below option from option and settings:-
Thanks,
Samarth