none
Date Format SSAS 2012 Tabular - Excel 2010

    Question

  • Hi all,

    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))"

    Do you have any idea?

    Thanks in advance

    massimo

    Friday, January 10, 2014 9:32 AM

Answers

  • as you say that you have several entries date-entries per day you are not using a date-table - right?

    you would get an error if you try to mark that table as a date-table

    in order to make aggregation correctly by single days you would need to create a calculated column as you already mentioned

    the aggregation is done by values and not by the formatting so if you have 3 different values for the same day which only vary by hours then you will always see 3 rows

    hth,
    gerhard


    - www.pmOne.com -

    Friday, January 10, 2014 9:52 AM
    Answerer