Dates with hours,

[Anonymous]

Hello,

I have in my data model the dates with hours, so there is more than one different value for each day.

This is an issue when I make a table with this date as a dimension, because I have more than one register for each day.

Is it possible group all the registers of one day in one unique value without using the script?

Thank you,

Sara

[sunny_talwar · Accepted solution]

Sure, while you create this in the script, use Floor() function

LOAD Date(Floor(DateField)) as Date

Or you can use the same in the list box expression:

=Date(Floor(DateField))

[MarcoWedel]

You can also use

DayName(yourtimestampfield) as Date

Regards

Marco