Forum Discussion

Mr_O's avatar
Mr_O
Frequent Visitor
7 years ago

User defined upper bound on percentage forecast?

Greetings. I'm brand new to Power BI so forgive me if this is answered elsewhere (I couldn't find it if so). 

 

I have a simple line graph that shows my percentage occupancy value measure by month. This value in reality will never stray north of 100%. However, when I apply a forecast to my values I do indeed exceed 100% in some cases in future months. Is there a simple way to create a user defined upper bound for a forecast?    

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Mr_O You can create a measure with your value in it as a upper bound and use that.

    • Mr_O's avatar
      Mr_O
      Frequent Visitor
      7 years ago

      Yeah, ok. I currently have it as a super simple measure: 

      Occupancy = [Occupied Units]/DISTINCTCOUNT([Unit Number])
       
      I tried wrapping this in a MIN function: MIN([Occupied Units]/DISTINCTCOUNT([Unit Number]),1). I think that should work in my mind's eye. My forecast still goes beyond 100% though.