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.
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?
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.
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.
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?