Poewr pivot new date table greyed out

[Anonymous]

Hi,

I want to add a New Date Table to an powerquery data table (data table created from a table in an Excel sheet). But the option is greyed out, the only thing I can do is to choose "Set Default". How can I fix this?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

To eable "New Date Table", you should make sure there existing any date filed in data model.

Best regards,

Yuliana Gu