Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date and time slicer issue

hi  have below column which i have exported from dynamic 365 and i have created date table with the following expression  calendar = ADDCOLUMNS(CALENDARAUTO() , "year" , YEAR([Date]), "mon...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • HotChilli's avatar
    HotChilli
    5 years ago

    Is the time in the 'created on' field important?  If not then set the data type to be Date.

    If it is, you'll need to think about it more carefully.

    If you want, you can duplicate the column , set the data type to Date and use that in the relationship

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

Is the time in the 'created on' field important?  If not then set the data type to be Date.

If it is, you'll need to think about it more carefully.

If you want, you can duplicate the column , set the data type to Date and use that in the relationship