cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wickstromhelena Frequent Visitor
Frequent Visitor

Poewr pivot new date table greyed out

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?

 

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Poewr pivot new date table greyed out

Hi @wickstromhelena ,

 

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

1.PNG2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Poewr pivot new date table greyed out

Hi @wickstromhelena ,

 

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

1.PNG2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.