i have a tabular model in SQL 2012 SP1 (11.0.3000.0).
In a table i have a datetime field. I change the data format in "ShortDate" to have only the date (without the time information).
In a PivotTable, with external connection to tabular model, if i put the field on Row and a measure on Values, the records don't aggregate the measure value by day, but it displays more records for the same day because it's affected by time information.
I would'nt like to add a new calculated column (with the formula "=date(year(DateField),month(DateField),day(DateField))"