Forum Discussion

bsheffer's avatar
bsheffer
Icon for Continued Contributor rankContinued Contributor
5 years ago
Solved

Forcast option disappears when I drilldown

I have a date hierarchy      year      quarterno      month mmm      date   value is a sales total measure   I want to drilldown and show a forcast on quarters   at the year level I can cre...
Need Help
  • bsheffer's avatar
    bsheffer
    5 years ago

    I was using a hierarchy in a date table that was built from the date field.  However this only seems to work with powerbi generated date hierarchies.  Once I turned off the date table and powerbi autogenerated hierarchies for all the date fields I was able to use forcast with one of them.

bsheffer's avatar
bsheffer
Icon for Continued Contributor rankContinued Contributor
5 years ago

I was using a hierarchy in a date table that was built from the date field.  However this only seems to work with powerbi generated date hierarchies.  Once I turned off the date table and powerbi autogenerated hierarchies for all the date fields I was able to use forcast with one of them.

MAHDI_ML_AI's avatar
MAHDI_ML_AI
Regular Visitor
1 year ago

Hi Guys 

I need code to obtain forcast values as same as below table ,  would appreciate your assistance 

 

WeekSubmissionSubmittedForcast
W12520 
W23523 
W335 38.5
W425 38.5

 

Thanks