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

Missing date hierarchy when marking as date table

Hi Guys,

 

I’ve got a problem with the date hierarchy. I have a self-created Date Table. BI recognizes the Date and automatically creates a date hierarchy. But when I use this table as a central data base I can’t use prediction functions.

 

835354538.png 

 

 

 

 

 

 

 

 

 

 

 

 

 

When I mark it as date table I can do predictions. But it loses the date hierarchy which I used all over my report. Any ideas why it

loses the date hierarchy when I mark it as a date table and how I can get both?

4556+56565.png

 

 

 

 

5 REPLIES 5
Highlighted
Memorable Member
Memorable Member

Re: Missing date hierarchy when marking as date table

If your data schema is not a complicated one, you can create a duplicate date table and use it with Date Hierarchy

Highlighted
Frequent Visitor

Re: Missing date hierarchy when marking as date table

My data scheme is quiet big and keeps rising. 

And I used my date hierarchy already in a lot of reports.

 

When I make a duplicate of the date table - one with hierarchy and one without - it still loses the hierarchy.

Highlighted
Community Support
Community Support

Re: Missing date hierarchy when marking as date table

Hi PHA369,

 

Does the "prediction function" you have mentioned mean quick measure? Quick measure can be created on usual field,  can't be created on hierarchy field but can be created in sub level field in a hierarchy. If you have other issues, please clarify more details about it.

 

Regards,

Jimmy Tao

Highlighted
Community Support
Community Support

Re: Missing date hierarchy when marking as date table

Hi PHA369,

 

Have you solved your issue by now? If you have, could you kindly mark one answer to finish the thread?

 

Regards,

Jimmy Tao

Highlighted
Frequent Visitor

Re: Missing date hierarchy when marking as date table

The "prediction function" I was talking about is in the Nalatytics pane in Power BI Desktop. It's supposed to show an expected forecast.
This function is lost when I use the date formated as I showed it in my picture above. 
What do you mean with sub level field in a hierarchy?

 

Regards

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors