Group by Date RRS feed

  • Question

  • I have a problem with PowerPivot for Excel when trying to group by date the data in table. The right click function Group is grayed out:

    I'm guessing that happens because excel treats PowerPivot date as plain text. So I tried to mark it as date table in PowerPivot, but here is error that I get:

    How could I resolve this issue?

    Monday, August 13, 2012 1:36 PM